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

      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...