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.



No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Thursday, 22 March 2018

Captcha Image

Mobile? Grab this Article!

Qr Code

Tag Cloud

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

Blog Archive

Sign Up For Our Newsletter!