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
Saturday, 23 June 2018

Captcha Image

Mobile? Grab this Article!

Qr Code

Tag Cloud

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

Sign Up For Our Newsletter!