Macatawa Technologies Logo

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!

Don't forget to share this post!

Topics

Recent Articles

Why Cable Management Matters in Managed IT Services

When businesses think about managed IT services, they often picture antivirus software, cloud backups, and 24/7 support - but cable management is often an afterthought. Servers are humming, computers are connected, and the Wi-Fi is working! So why does it matter if...

Hackers Have AI. So Should Your Defenses.

Impressed with how smart Artificial Intelligence is? Now imagine it has bad intentions and no rules. That is what hackers are using it for today. Artificial intelligence has become a very powerful tool for cybercriminals. It is able to mimic human behavior, bypass...

Windows 10 End of Life

Did you know that Microsoft will officially stop supporting their Windows 10 Operating System on October 14, 2025? What This Means for You: Microsoft will end its maintenance and updates for computers running Windows 10 after this date. This includes the...

You may also like…

Windows 10 End of Life

Windows 10 End of Life

Did you know that Microsoft will officially stop supporting their Windows 10 Operating System on October 14,...