Voyage Tech Blogs

Voyage Technology has been serving the Beaver Dam area since 1999, 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

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
Thursday, 18 January 2018

Captcha Image

Mobile? Grab this Article!

Qr Code

Tag Cloud

Security Tip of the Week Best Practices Hackers Technology Cloud Privacy Internet Email Malware Business Microsoft Windows 10 Business Computing Hosted Solutions Productivity Android Smartphone Small Business Computer User Tips Hardware IT Services Gmail Ransomware Browser Google Workplace Tips Internet of Things Smartphones Mobile Devices Managed Service Provider Upgrade Backup Saving Money Windows Office Tips Data Data Management Artificial Intelligence Facebook App Innovation Network Security Microsoft Office Two-factor Authentication Efficiency Firewall Office 365 IT Support WiFi Business Management Miscellaneous Tip of the week Employer-Employee Relationship Spam Social Media Encryption Printing Hacker Content Filtering Office Outsourced IT Wireless Technology Wi-Fi Passwords Computing Server Software Website Managed IT Services Risk Management Mobile Device Management LiFi Data storage Robot End of Support Scam Money Safety Communication The Internet of Things Government Bandwidth Business Continuity Big Data Social Mouse Bring Your Own Device Disaster Recovery Holiday Apple Administration Apps Automation Phishing Going Green Customer Service Network Hacking Settings Presentation Computers Wireless Printer User Retail Downtime Hosted Solution Smart Technology Operating System Typing Cybercrime Language Virtual Private Network Access Control Avoiding Downtime Social Engineering YouTube IP Address communications Knowledge Distributed Denial of Service Tablet Google Drive Cryptocurrency Computing Infrastructure Data Backup 5G SharePoint Recovery Marketing Information Technology Mobile Office Unified Communications Experience Managed IT Service Hard Drives Cybersecurity Google Docs Dark Data Bitcoin Running Cable Alerts Domains Lenovo Word Downloads How To Google Wallet Virtual Desktop Break Fix Refrigeration IT Support Windows 8 Laptop Public Speaking Superfish Multi-Factor Security Save Money Drones Lithium-ion battery Analytics Dark Web Maintenance Entrepreneur Outlook Halloween Augmented Reality Google Calendar Alert Chrome Microsoft Excel Undo Remote Monitoring Humor Network Congestion Hacks Scary Stories Networking Fun Legislation Budget Deep Learning Blockchain Virtualization Windows 10 Storage Display Password Sports Data Security Comparison Application BYOD Education Permissions Monitors Gadgets Mobile Computing IBM Techology Search Specifications Best Practice VoIP Fraud Antivirus Unified Threat Management Users Current Events Buisness Customer Relationship Management IT solutions Black Friday Unified Threat Management Legal Business Growth Mobile Security Competition Data Recovery User Error Writing Cortana Cyber Monday Productivity Alt Codes Hotspot Vulnerability

Blog Archive

Sign Up For Our Newsletter!