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, 15 December 2018

Captcha Image

Mobile? Grab this Article!

Qr Code

Tag Cloud

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

Sign Up For Our Newsletter!