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.

 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Friday, 20 April 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!

      freeconsultation
       

      Tag Cloud

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

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