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

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