Excel Keyboard Shortcuts: 50+ Time-Saving Keys for Windows and Mac
You are building a report. Your hand leaves the keyboard, grabs the mouse, clicks a menu, and then goes back to typing. That small move happens hundreds of times a day. It adds up fast.
Excel keyboard shortcuts fix that. A shortcut is a short key combo that does a job in one second. No menus. No hunting for buttons.
This article covers the Excel keyboard shortcuts that matter most. They are grouped by task, so you can find what you need fast. Every shortcut works in Excel for Windows. When the Mac version is different, I say so.
Why Excel Keyboard Shortcuts Are Worth Your Time
Speed is the first reason. If a shortcut saves three seconds and you use it 100 times a day, you get five minutes back. Do that all week, and it adds up to real time.
There are other gains too:
- Your hands stay on the keys, so your wrists and shoulders do less reaching.
- You make fewer mistakes, because you click fewer wrong buttons.
- Your work flows better, since you stay focused on the numbers.
- Co-workers notice when you move through a sheet with ease.
Microsoft’s own support page for Excel shortcuts says shortcuts are also a big help for people who find a mouse hard to use. So they help with speed and with access.
The 10 Most Used Excel Keyboard Shortcuts
If you only memorize one section, make it this one. These are the Excel keyboard shortcuts you will press all day.
- Ctrl + C: Copy the selected cells
- Ctrl + V: Paste what you copied
- Ctrl + X: Cut the selected cells
- Ctrl + Z: Undo your last step
- Ctrl + Y: Redo what you just undid
- Ctrl + S: Save your file
- F12: Save As, to make a new copy with a new name
- Ctrl + F: Find a word or number
- Ctrl + A: Select all cells (press it again inside a data range to select the whole sheet)
- Ctrl + P: Print or open the print preview
On a Mac, use the Command key in place of Ctrl for most of these.
Excel Keyboard Shortcuts for Moving Around a Sheet
Scrolling with the mouse is slow in a big file. These keys get you there in one press.
- Ctrl + Arrow key: Jump to the edge of your data
- Ctrl + Home: Go back to cell A1
- Ctrl + End: Go to the last cell that has data
- Home: Go to the first cell in the current row
- Ctrl + Page Down: Move to the next sheet
- Ctrl + Page Up: Move to the previous sheet
- Ctrl + G or F5: Open the Go To box and type any cell address
- Ctrl + Backspace: Bring the active cell back into view after you scroll away
Here is a simple test. Say your list has 5,000 rows. Click the top cell. Press Ctrl + Down Arrow. You land on the last row at once.
Select Cells, Rows, and Columns Fast
Selecting is something you do before almost every task. These shortcuts make it quick.
- Ctrl + Space: Select the whole column
- Shift + Space: Select the whole row
- Shift + Arrow key: Add one cell to your selection
- Ctrl + Shift + Arrow key: Select all the way to the edge of your data
- F8: Turn on Extend mode, so the arrow keys select cells without holding Shift
Try this one today: click the first cell in a column of numbers and press Ctrl + Shift + Down Arrow. The whole column of data is selected. No dragging needed.
Editing Shortcuts That Save the Most Clicks
These Excel keyboard shortcuts help you type, fill, and fix cells with less work.
- F2: Edit the active cell without double-clicking
- Ctrl + D: Fill the cell above down into your selection
- Ctrl + R: Fill the cell on the left across to the right
- Ctrl + E: Use Flash Fill to copy a pattern you started typing
- Ctrl + Enter: Put the same entry in all selected cells
- Alt + Enter: Start a new line inside one cell
- Ctrl + ;: Insert today’s date
- Ctrl + Shift + :: Insert the current time
- Ctrl + Alt + V: Open Paste Special, so you can paste only values or formats
- F4: Repeat your last action
- Delete: Clear what is in the selected cells
Flash Fill is a fun one. Say column A has full names like “Sara Khan”. In column B, type “Sara” next to the first name. Press Enter. Start the next one, and hit Ctrl + E. Excel spots the pattern and fills the rest.
On a Mac, the edit shortcut is Control + U instead of F2.
Formatting Shortcuts for Cleaner Sheets
Good formatting makes numbers easy to read. You can do most of it from the keyboard.
- Ctrl + 1: Open the Format Cells box
- Ctrl + B: Bold
- Ctrl + I: Italic
- Ctrl + U: Underline
- Ctrl + 5: Strikethrough (our post on the keyboard shortcut for strikethrough shows how it works across other apps too)
- Ctrl + Shift + $: Apply currency format
- Ctrl + Shift + %: Apply percent format
- Ctrl + Shift + #: Apply date format
- Alt, then H, O, I: Auto-fit the column width (press each key one after the other)
Work With Rows, Columns, and Sheets
Adding and removing rows is a daily job in most files. These keys make it easy.
- Ctrl + Shift + +: Insert new cells, rows, or columns (our page on the row insert shortcut key in Excel covers the steps in more detail)
- Ctrl + –: Delete the selected cells, rows, or columns
- Ctrl + 9: Hide the selected rows
- Ctrl + 0: Hide the selected columns
- Ctrl + Shift + 9: Unhide rows
- Shift + F11: Add a new worksheet
- Ctrl + Shift + L: Turn filters on or off
If Ctrl + Shift + 0 does nothing, a Windows language setting may be using that combo. Right-click the column header and choose Unhide instead.
Formula and Data Shortcuts
If you work with numbers, these Excel keyboard shortcuts will feel like a gift.
- Alt + =: Add up a range with AutoSum
- F4 (while typing a formula): Switch between A1, $A$1, A$1, and $A1
- Ctrl + Grave accent (the key above Tab): Show all formulas on the sheet, then press again to go back
- F9: Recalculate your workbook
- Ctrl + [: Jump to the cells a formula uses
- Ctrl + T: Turn a range into a table
- Alt, then N, V: Start a PivotTable
- Alt + F1: Add a chart on the same sheet
- F11: Add a chart on its own new sheet
- Ctrl + Shift + Enter: Enter an array formula in older versions of Excel
The F4 key needs a note. Type a formula like =B2*C2. Press F4 right after a cell name. Excel adds dollar signs to lock that cell. This saves a lot of typing when you copy a formula down a column.
Excel Keyboard Shortcuts on Mac
Most Windows shortcuts work on a Mac if you swap Ctrl for Command. A few are different. These are the ones people miss:
- Control + U: Edit the active cell (Windows uses F2)
- Command + Shift + T: AutoSum
- Command + Y or Command + Shift + Z: Redo
- Command + Q: Quit Excel
- Fn key: Many Macs need you to hold Fn to use the F1 to F12 keys, unless you change this in System Settings
For a wider look at Mac key combos outside Excel, see our list of Mac keyboard shortcuts.
The Alt Key Trick: Use the Ribbon Without a Mouse
You do not need to memorize every shortcut. Excel gives you a free map.
Press the Alt key once. Small letters pop up over each ribbon tab. Press the letter for a tab. More letters appear over each button. Keep going until you reach the command you want.
For example, Alt, then H, then O, then I auto-fits a column. The letters are the same each time, so after a few tries your fingers remember the path. This one trick gives you access to hundreds of commands that have no direct shortcut.
How to Remember Excel Keyboard Shortcuts
Reading a list feels easy. Remembering it is hard. These habits help:
- Pick three shortcuts per week. Do not try to learn 50 at once.
- Write them on a sticky note and put it on your monitor.
- Use them on real work, not only in practice files.
- When you catch yourself reaching for the mouse, stop and ask if there is a key combo for it.
- Start with the shortcuts you would use most, such as copy, paste, undo, and fill down.
After about two weeks, the first group feels automatic. Then add the next three.
Why Your Excel Keyboard Shortcuts Might Not Work
Sometimes a shortcut does nothing. Before you give up, check these causes:
- You are in edit mode. Many shortcuts will not work while the cursor blinks inside a cell. Press Enter or Esc first.
- Fn Lock is on. On many laptops, the F keys also control volume or brightness. Check your Fn Lock key.
- Another app is using the same keys. Screen recorders, language tools, and chat apps can grab key combos.
- Your keyboard layout is different. Microsoft lists its shortcuts for the US keyboard layout, so some symbols sit in other places on other keyboards.
- You pressed keys in the wrong order. Hold the first key, then tap the next one. The Alt shortcuts are the exception: press and release each key in turn.
Frequently Asked Questions
What is the most useful Excel shortcut?
It depends on your work, but two stand out. Ctrl + Z saves you from mistakes, and Ctrl + Arrow key saves you the most time in large sheets.
How do I see all the shortcuts in Excel?
Press the Alt key to see the ribbon letters. For a full list, open Microsoft’s shortcut page linked earlier in this article.
Do Windows shortcuts work on a Mac?
Many do. Swap Ctrl for Command and try it. A few, like edit cell and AutoSum, use different keys, as shown in the Mac section above.
Can I create my own shortcut in Excel?
Yes. Record a macro, and in the Macro Options box, assign a letter. You can then run it with Ctrl plus that letter. Pick a letter that Excel does not already use.
How many Excel keyboard shortcuts should I learn?
Start with 10 to 15. That covers most daily tasks. Add more only when you notice a task that feels slow.
Final Thoughts
Excel keyboard shortcuts are a small habit with a big payoff. You do not need to learn them all. Start with copy, paste, undo, fill down, and Ctrl + Arrow, then add a few more each week.
If you want one more list to keep on hand, check our page on Microsoft Excel shortcuts. Bookmark this page too, and come back whenever you want to add a new key combo to your routine.
