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
Monday, December 17 2018

Captcha Image

Subscribe to Our Blog!

Mobile? Grab this Article!

Qr Code

Tag Cloud

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

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