BNMC Blog

Tip of the Week: Excel-lent Keyboard Shortcuts

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
Sunday, September 23 2018

Captcha Image

Subscribe to Our Blog!

Mobile? Grab this Article!

Qr Code

Tag Cloud

Security Tip of the Week Best Practices Technology Cloud Privacy Email Malware Hackers Business Computing Network Security Microsoft Software Internet Computer Hosted Solutions Tech Term Google IT Services Ransomware Business Mobile Devices Android Managed IT Services Backup User Tips Smartphone Small Business Internet of Things Data Management Cloud Computing Efficiency Saving Money Business Continuity Hardware IT Support Innovation Windows Data Recovery Communication Productivity Cybersecurity Data App Browser Data Backup Windows 10 Facebook Server Artificial Intelligence Gmail Remote Monitoring Encryption Business Management Managed IT Services Passwords Outsourced IT Chrome Word Managed Service Provider Phishing Office 365 Employer-Employee Relationship Analytics Windows 10 communications Tip of the week Applications Microsoft Office Network Money Disaster Recovery Infrastructure IT Support Vulnerability Smartphones Productivity Google Drive Settings Content Filtering Bandwidth Upgrade YouTube Government Social Media Risk Management Website BYOD Data storage Antivirus Office Tips Big Data Robot Save Money IT Management Maintenance Server Management Automation Managing Stress Administration Business Technology Mouse Touchscreen End of Support Virtual Private Network Virtual Reality Miscellaneous Wireless Workplace Tips Apple SaaS HIPAA Storage Mobile Device Holiday Mobile Security Two-factor Authentication Paperless Office Avoiding Downtime Scam Alert Information Business Intelligence Unified Threat Management Laptop Data loss Spam Computing Telephone Systems Outlook The Internet of Things Vendor Management Monitors desktop Company Culture WiFi LiFi VoIP VPN Hosted Solution Data Security Firewall Marketing Websites Computing Infrastructure Professional Services Best Practice Legislation Social Networking Current Events Document Management Spyware Troubleshooting Star Wars SharePoint Uninterrupted Power Supply Chatbots eWaste Microsoft Excel Gadgets Nanotechnology Development Apps Quick Tips Techology File Sharing Wearable Technology Network upgrade Cryptocurrency Managed IT Smart Technology Safety Computer Care IBM Spying How To Lenovo Alerts USB Google Docs Statistics Tablet Remote Computing Solid State Drive Analysis Motherboard Cables IT solutions Going Green Halloween Identity Theft Fraud Cost Management Downloads Network Congestion Identity Continuity Education Hacks Mail Merge Blockchain Users Screen Reader Charging Google Wallet VoIP Unified Threat Management Smart Office Bitcoin Shortcut Distributed Denial of Service Training Corporate Profile Employee-Employer Relationship Firefox Superfish Wi-Fi Automobile Licensing Dongle Business Growth Bluetooth Comparison Writing Hard Disk Drive Managed Service Wires Printing Scary Stories Assessment Legal Computers Dell Solar Password Address Permissions PowerPoint Smart Tech Unified Communications Drones User Error Dark Data Cabling Work Windows 8 Patch Management Managed IT Service Running Cable WannaCry Customer Relationship Management Buisness Google Maps Cooperation Service Level Agreement Hacker Specifications Retail Router Voice over Internet Protocol Politics Sports Hotspot Internet Exlporer Deep Learning Heating/Cooling Multi-Factor Security Display Virtual Desktop Compliance Onboarding Connectivity Time Management Printer Customer Service IT Technicians Optimization Break Fix Networking Staff Leominster Alt Codes Search Black Friday Office Samsung Slack Modem FinTech Tech Support Digital Payment Language Value Bring Your Own Device Operating System Servers Google Calendar Regulations Emergency Digital Digital Signage IoT Budget Network Management Access Control Chromebook Disaster Mirgation Recycling Social Dark Web MSP Information Technology Downtime Collaboration Augmented Reality K-12 Schools Typing Humor Cyber Monday Social Engineering Cybercrime Monitoring Cookies Physical Security Twitter CCTV Emoji Webcam Upgrades Gadget Crowdsourcing Personal Information Botnet Error Printers Cortana Point of Sale Ben McDonald shares 3D Printing Travel Machine Learning Processors G Suite BDR Unsupported Software Supercomputer CrashOverride Virtualization Regulation Update Motion Sickness Staffing Computer Repair Relocation Administrator Taxes Mobile Data IT Budget Web Server what was your? Mobile Device Management Recovery How To Work/Life Balance GPS Health Private Cloud IT Consultant Black Market Cameras Mobile Computing Tracking Meetings Law Enforcement Electronic Medical Records Notifications Cleaning

What Our Clients Say

  • BNMC has provided us with nothing less than outstanding service and results for all of our IT needs for the past few years. Every member of their staff is professional, knowledgeable, friendly and eager to solve any problem...
  • 1
  • 2
  • 3