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
Tuesday, 25 September 2018

Captcha Image

Mobile? Grab this Article!

Qr Code

Tag Cloud

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

Sign Up For Our Newsletter!