Skip to content

Microsoft Excel: Useful Keyboard Shortcuts for Windows and Mac

Microsoft Excel is a great tool to organize data into spreadsheets, but it’s kind of a tricky beast to master. As is the case with most software programs, you can add an extra level of mastery to your skillset by having a full understanding of keyboard shortcuts. We’ve listed some of the most common shortcuts that you might use during your day-to-day duties in Microsoft Excel.

You can even print out this blog article and use it as a resource throughout the workday! That way, you’ll have a quick reference should you ever need one.

Excel Shortcuts on windows

  • 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: windows

If you want to add information into cells, there are various shortcuts to doing so as well:

  • 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 + @

Excel Shortcuts on mac os

  • Cut: Command + X
  • Copy: Command + C
  • Paste: Command + V
  • Open a Workbook: Command + O
  • Close a Workbook: Command + W
  • Save a Workbook: Command
  • Undo: Command + Z
  • Navigate between cells and menu options: Arrow Keys
  • Expand/Collapse Ribbon: Command + ⌥ + R
  • Move to the beginning of the worksheet: Fn + Left
  • 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: mac os

If you want to add information into cells, there are various shortcuts to doing so as well:

  • 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 + @

This only scratches the surface of what Excel is capable of. If you want even more keyboard shortcuts in addition to the ones that we’ve picked out, Microsoft details even more of them on its website.

What other tips are you hoping to see from us in the future? Let us know in the comments, and be sure to check back every week for even more blogs about how to be more productive throughout the workday.

a person using a laptop computer on a wooden table

Cybersecurity in the Age of Remote Work

https://youtu.be/KV9kgmFj_sM Facing the challenges of remote work requires a proactive approach to cybersecurity measures to ensure the protection of sensitive

Phishing Attack

What to Do After a Phishing Attack

https://www.youtube.com/watch?v=wP42Et2mOGI If you’ve ever wondered what steps to take after falling victim to a phishing attack, rest assured that there

Let's Start a Conversation

Watch the video below and find out why you should fill out this form and start a conversation today.

"*" indicates required fields

Name*
This field is for validation purposes and should be left unchanged.