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.

Excel Shortcuts You Can Use to Be More Efficient

Excel Shortcuts You Can Use to Be More Efficient

Microsoft Excel is the premier spreadsheet software, but unless you know keyboard shortcuts and formulas, it can be tricky to get the most value out of it as a software solution. Thankfully, with just a couple of keystrokes, you too can achieve mastery over this software. Here are some of the most popular and useful keyboard shortcuts for Microsoft Excel.

We also want to encourage you to print out this blog article and use it as a resource throughout the workday. You might find it helpful to have a quick reference!

  • Cut: Ctrl + X
  • Copy: Ctrl + C
  • Paste: Ctrl + V
  • Open a Workbook: Ctrl + O
  • Close a Workbook: Ctrl + W
  • Save a Workbook: Ctrl + S
  • Undo: Ctrl + Z
  • Navigate between cells and menu options: Arrow Keys
  • Expand/Collapse Ribbon: Ctrl + F1
  • Move to the beginning of the worksheet: Ctrl + Home
  • Move to the next sheet in the workbook: Ctrl + Page Down
  • Move to the previous sheet in the workbook: Ctrl + Page Up

Entering Information in Cells

You can also use various keyboard shortcuts to enter values into your cells:

  • Enter the current time: Ctrl + Shift + :
  • Enter the current date: Ctrl + ;
  • Apply the General Number format: Ctrl + Shift + ~
  • Apply the Currency format with two decimal places: Ctrl + Shift + $
  • Apply the Percentage format with no decimal places: Ctrl + Shift + %
  • Apply the Scientific number format with two decimal places: Ctrl + Shift + ^
  • Apply the Date format with the day, month, and year: Ctrl + Shift + #
  • Apply the Time format with the hour and minute, and AM or PM: Ctrl + Shift + @
  • Apply the Number format with two decimal places, thousands separator, and minus sign for negative values: Ctrl + Shift + !

As you might expect, this is only a small fraction of what Excel can do if you know enough about it. If you want even more keyboard shortcuts in addition to these, Microsoft details even more of them on its website.

If you have any recommendations for future tips, be sure to leave them in the comments. We’ll do our best to cover all topics our readers are interested in!

 

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

Blog Archive