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

Blog Archive