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
Friday, 28 February 2025

Captcha Image

Sign Up For Our Newsletter!

Mobile? Grab this Article!

Qr Code

Tag Cloud

Security Technology Tip of the Week Best Practices Business Computing Data Productivity Business Software Innovation Hackers Cloud Network Security User Tips Internet Hardware Efficiency IT Support Malware Privacy Email Google Phishing Workplace Tips Computer Collaboration Users IT Services Hosted Solutions Mobile Device Quick Tips Ransomware Microsoft Cybersecurity Workplace Strategy Small Business Data Backup Communication Passwords Smartphone Saving Money Smartphones VoIP Android Business Management Mobile Devices communications Backup Data Recovery Upgrade Managed Service Social Media Managed IT Services Browser Disaster Recovery Microsoft Office Windows Tech Term Network Internet of Things Remote Automation Facebook Artificial Intelligence Cloud Computing Covid-19 Miscellaneous Gadgets Current Events Productivity Server Managed Service Provider Remote Work Outsourced IT Information Holiday Spam Encryption AI Employee/Employer Relationship Windows 10 Business Continuity Compliance Office Government Training Data Management Blockchain Wi-Fi Windows 10 Business Technology Virtualization Bandwidth Apps Data Security Mobile Office Two-factor Authentication Employer-Employee Relationship Apple Networking App Vendor Mobile Device Management Gmail Chrome Managed Services Budget Voice over Internet Protocol How To BDR Hacker Avoiding Downtime BYOD Computing Marketing Applications Information Technology Access Control Office 365 Tip of the week WiFi Conferencing Storage Healthcare Password Bring Your Own Device Managed IT Services Computers Operating System HIPAA Router Website Risk Management Virtual Private Network Health Help Desk Analytics Office Tips Augmented Reality Big Data Retail Social Telephone Scam Data loss Cooperation Free Resource Project Management Customer Service Windows 7 Going Green Patch Management Save Money Microsoft 365 Remote Monitoring End of Support Vulnerability Vendor Management Solutions Cybercrime Display Printer Paperless Office Windows 11 Firewall Infrastructure 2FA Monitoring Excel IT Support Document Management The Internet of Things Remote Workers Maintenance Sports Downloads Antivirus Mouse iPhone Licensing Entertainment Administration Customer Relationship Management Vulnerabilities Data Privacy Images 101 Hacking Multi-Factor Authentication Presentation Robot Mobility Telephone System Cost Management Settings Wireless Technology Wireless Printing Content Filtering IT Management YouTube Meetings VPN Employees Physical Security Integration Cryptocurrency Modem Word User Tip Processor Computer Repair Mobile Security Virtual Desktop Holidays Data storage LiFi Data Storage Smart Technology Supply Chain Outlook Video Conferencing Safety Machine Learning Managed Services Provider Money Saving Time Virtual Machines Professional Services Humor Managed IT Service Deep Learning Download Net Neutrality Twitter Alerts SQL Server Technology Care Application Error History Business Communications Financial Data Browsers Smartwatch Education Connectivity IT IBM Social Engineering Break Fix Scams Upload Procurement Remote Computing Azure Hybrid Work Cyber security Multi-Factor Security Tech Human Resources Mobile Computing Social Network Telework CES Tablet IoT Communitications Search Dark Web Cables Best Practice Trends Supply Chain Management Alert Buisness File Sharing Regulations Competition Dark Data Google Calendar Term Google Apps Managed IT Customer Resource management FinTech Legal Data Analysis IT solutions Star Wars IT Assessment How To Microsoft Excel IT Maintenance Business Growth Gamification Flexibility Notifications Staff Value Business Intelligence Travel Social Networking Legislation Shortcuts Organization Techology Fileless Malware Digital Security Cameras Google Maps Smart Devices Cortana Ransmoware User Alt Codes Content Remote Working Wearable Technology Memory Vendors Downtime Unified Threat Management Motherboard Data Breach Comparison Google Play Be Proactive Health IT Unified Threat Management Directions Videos Hosted Solution Assessment Electronic Health Records IP Address Permissions Workforce Typing Wasting Time Threats Trend Micro Network Congestion Specifications Security Cameras Workplace Strategies Google Drive User Error Microchip Internet Exlporer Software as a Service Knowledge Fraud Meta Recovery Hard Drives Username Managing Costs Amazon Point of Sale eCommerce Domains 5G Black Friday SSID Google Docs Unified Communications Database Surveillance Experience Virtual Assistant Outsource IT Refrigeration Media Bitcoin Network Management Running Cable Tech Support IT Technicians Virtual Machine Environment Cookies Public Speaking Monitors Cyber Monday Medical IT Google Wallet Proxy Server Reviews Tactics Development Lithium-ion battery Hotspot Transportation Small Businesses Entrepreneur Windows 8 Laptop Websites Mirgation Hypervisor Displays Nanotechnology Optimization PowerPoint Drones Shopping SharePoint Addiction Electronic Medical Records Language Employer/Employee Relationships Outsourcing Undo Navigation Management PCI DSS Halloween Chatbots Lenovo Gig Economy Screen Reader Writing Distributed Denial of Service Workplace Service Level Agreement Internet Service Provider Virtual Reality Computing Infrastructure Teamwork Hiring/Firing Scary Stories Private Cloud Identity Evernote Paperless Hacks Server Management Regulations Compliance Superfish Bookmark Identity Theft Smart Tech Memes Fun Co-managed IT

Blog Archive