crn5000-inc2015 BPTW logo
Contact us today!
(918) 770-8738

Integrated Business Technologies Blog

Integrated Business Technologies has been serving the Broken Arrow area since 2007, providing IT Support such as technical helpdesk support, computer support, and consulting to small and medium-sized businesses.

Tip of the Week: Excel-lent Keyboard Shortcuts

How well do you know Microsoft Excel, the premier spreadsheet building software? Depending on your proficiency with it, you may already be familiar with some of the various keyboard shortcuts associated with it. We’ll list off some of the most commonly used keyboard shortcuts, as well as what you can do to become a Microsoft Excel power user.

Before we get started, keep in mind that most keyboard shortcuts that work with Microsoft Word and other products in the Office suite will also work in Excel. We’re talking about the good old staples of Copy, Cut, Paste, Find, and so much more. Be sure to try out some of your favorites to see if they work in Excel, too.

Check Formulas in Cells
Excel doesn’t show you your formulas in the cells--it instead shows the results of the formulas. While you can click on the cell and view the formula bar at the top of the spreadsheet to see how the results are showing up, this can take some time if you’re checking an entire row or column. To toggle between a spreadsheet containing your values and your formulas, you can use the Ctrl + ` keyboard shortcut.

Place Borders Around Cells
If you’re not too concerned with the specific border you want for your cells, just use the keyboard shortcut Ctrl + Shift + 7. This will surround the selected cells with a nice, simple border that’s very minimalist, but gets the job done.

Remove Borders from Cells
There’s a keyboard shortcut to remove borders from cells, too. It’s as easy as pressing Ctrl + Shift + - (minus). It’s the perfect solution to a botched border job.

Select an Entire Row or Column
You can select the contents of an entire row by clicking on the first cell in the row and hitting Shift+Spacebar. On the other hand, you can do the same for a column by pressing Ctrl+Spacebar.

Format an Object or Chart
Let’s say you want to insert a picture or a chart into an Excel spreadsheet, but you don’t know how to format it. You can use the keyboard shortcut Ctrl+1 to bring up the proper formatting dialogue box.

Do you have a favorite Microsoft Excel shortcut? Leave it for us in the comments, and be sure to subscribe to our blog.



No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Tuesday, 23 October 2018
If you'd like to register, please fill in the username, password and name fields.

Captcha Image

Sign Up for Our Newsletter

  • First Name *
  • Last Name *

      Free Consultation

      Sign up today for a
      FREE Network Consultation

      How secure is your IT infrastructure?
      Let us evaluate it for free!

      Sign up Now!


      Tag Cloud

      Security Technology Tip of the Week Privacy Managed Service Provider Business Management Cloud Internet Microsoft Business Computing Best Practices Saving Money Productivity Workplace Tips IT Services Hosted Solutions Hackers Backup Email Malware Business Software Mobile Devices Data IT Support Network Hardware Small Business Communication Server Smartphones VoIP Computer Upgrade Business Continuity Google Windows Efficiency Disaster Recovery Mobile Device Management Innovation Microsoft Office Virtualization Data Backup Tech Term Outsourced IT Miscellaneous Mobile Office Vendor Management Holiday Gadgets Social Media Passwords BYOD Network Security User Tips Quick Tips Mobile Computing Browser Android Smartphone Productivity WiFi Internet of Things Bring Your Own Device Managed IT services Windows 10 The Internet of Things Remote Monitoring Ransomware Spam Data Recovery Best Practice Trending Wireless Technology Operating System Apple Remote Computing Artificial Intelligence Alert Users Data Management Save Money Content Filtering Going Green History Gmail Encryption Firewall Office Customer Relationship Management Collaboration Unified Threat Management Facebook Cloud Computing Managed IT IT Consultant Router Printer Tech Support IT Support Information Technology Current Events Big Data App Analytics IT Solutions Lithium-ion Battery Windows 8 Antivirus Phishing Document Management Humor Applications Mobile Device Saving Time Avoiding Downtime Employer-Employee Relationship Website Maintenance Hard Drives Paperless Office Two-factor Authentication Marketing Automation Excel Office Tips Retail IT service Digital Payment Chrome Government Business Growth VPN Managed IT Services Wi-Fi Risk Management Apps Application Compliance Virus Customer Service Hacking Computers Bandwidth Fax Server Project Management Cybersecurity Phone System Outlook Health Unified Communications Budget Proactive IT Data Security Computer Repair Point of Sale Inbound Marketing Mouse Recovery Money Healthcare Infrastructure Net Neutrality Running Cable Social Licensing File Sharing PowerPoint Social Networking Training Tablet Managed Service Regulations Office 365 Files Help Desk Password iPhone User Error Co-Managed IT Administration Presentation Augmented Reality Search Piracy IoT Virtual Desktop USB Robot Business Owner Windows 10 Printing Sports End of Support LiFi Hacker Tip of the week Scam User Programming Computing Company Culture Analyitcs Twitter Education Specifications Safety Settings IBM Cost Management Wireless Remote Workers Cybercrime Save Time Wearable Technology Vulnerability Conferencing Information Hiring/Firing Display Alerts Data loss Blockchain HIPAA BDR Redundancy Statistics Intranet Competition Machine Learning Business Intelligence Network Congestion Flexibility Recycling Hosted Solution Internet Exlporer Storage eWaste Downtime Mobility Smart Technology Data storage Mobile Security Knowledge Migration E-Commerce Environment Public Cloud Downloads Hacks Adminstration WPA3 3D Distributed Denial of Service Bluetooth Online Currency Networking Samsung Vulnerabilities Hotspot Experience Chatbots Features Troubleshooting Sync Multi-Factor Security Debate Fleet Tracking Computer Accessories Star Wars Heating/Cooling Software Tips Managed IT Service Consumers Virtual Reality Crowdfunding Geography Language Identity Electronic Health Records Mobile Device Managment Google Calendar Asset Tracking Utility Computing Break Fix Monitors SaaS Techology Deep Learning Scheduling High-Speed Internet IP Address Server Management Computing Infrastructure OneNote Cyberattacks Legislation Google Wallet Touchscreen Refrigeration Dark Web Disaster Writing Cooperation Chromebook Disaster Resistance Development Employee-Employer Relationship Motherboard Read Only G Suite Drones Buisness Hard Drive Data Warehousing Digital Signature Social Engineering Patch Management Staff IT Consulting Memory Identities Cables Laptop Modem Bookmarks Travel Software as a Service Backups CIO Cache Microsoft Excel Operations Documents Politics Data Breach Solid State Drive Wires Halloween Cookies Favorites Entrepreneur Meetings Technology Tips Legal Macro PC Care Management Undo 5G Virtual Private Network PDF Telephony Technology Laws Value People Alt Codes eBay Monitoring Scary Stories Nanotechnology Instant Messaging Comparison Remote Support YouTube Leadership Enterprise Resource Planning How To Permissions IT Technicians Skype Unified Threat Management Streaming Media Typing New Additions MSP Text Messaging Screen Reader Identity Theft Black Friday Print Server Google Drive Gaming Console How To Work Station Mobile Domains Assessment Fraud Fun Mirgation Consulting LinkedIn Access Control Cryptocurrency Congratulations Proactive Video Surveillance Smart Tech Word Cyber Monday Law Firm IT Google Docs Windows 8.1 Update Managing Stress Public Speaking IT Management Cortana Business Technology Managed Services Provider Best Available Private Cloud SharePoint Bitcoin Remote Monitoring and Management Connectivity communications Enterprise Content Management Network Management

      Top Blog

      Basically, any machine that uses fans and vents to cool itself can overheat if airflow is restricted. If you have used a laptop on your lap for an extended session, then you know what we are talking about when the computer becomes hot to the touch. Every portable device is designed a little diffe...