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

Blog Archive