30 Advanced Excel Tips for 2026

Excel Shortcuts Cheat Sheet: 228 Keyboard Shortcuts for Windows and Mac

Keyboard shortcuts are one of those Excel skills that save you time every single day. Once your hands stay on the keyboard, you stop hunting for buttons on the ribbon, and the work moves faster.

On this page, I have listed more than 200 Excel keyboard shortcuts, grouped by the task you want to do, with the Windows and Mac keys side by side. They work in Excel for Microsoft 365 and Excel 2016 to 2024 on Windows, and in Excel for Microsoft 365, 2024 and 2021 on a Mac. Where a shortcut needs Microsoft 365, I have marked it. You can also download the full list as a free printable PDF.

How to read the keys: a plus sign (+) means press the keys together, and a comma means press them one after another (for example, Alt, H, A, C). On a Mac laptop, you may need to hold Fn to use F1 to F12. A dash (—) means there is no standard shortcut for it on that platform.

Free PDF cheat sheet: all the shortcuts on this page, Windows and Mac, on a printable sheet.

Download the Excel Shortcuts PDF

Top 10 Excel Shortcuts to Learn First

If you are just starting, learn these ten first. They cover most of what you do in Excel every day.

Action
Windows
Mac
Copy and paste
Ctrl + C, Ctrl + V
Cmd + C, Cmd + V
Undo and redo
Ctrl + Z or Ctrl + Y
Cmd + Z or Cmd + Y
Jump to the edge of the data
Ctrl + Arrow key
Cmd + Arrow key
Select to the edge of the data
Ctrl + Shift + Arrow key
Cmd + Shift + Arrow key
Select the entire column or row
Ctrl + Space or Shift + Space
Control + Space or Shift + Space
Open Format Cells
Ctrl + 1
Cmd + 1
Edit the active cell
F2
F2 or Control + U
Lock a cell reference in a formula
F4
Cmd + T or F4
Insert AutoSum
Alt + =
Cmd + Shift + T
Turn filters on or off
Ctrl + Shift + L
Cmd + Shift + F

Workbook and Worksheet Shortcuts

These shortcuts help you open, save, close and move between workbooks and worksheets.

Action
Windows
Mac
Create a new workbook
Ctrl + N
Cmd + N
Open a workbook
Ctrl + O
Cmd + O
Save the workbook
Ctrl + S
Cmd + S
F12
Cmd + Shift + S
Ctrl + P
Cmd + P
Ctrl + W or Ctrl + F4
Cmd + W
Close Excel
Alt + F4
Cmd + Q
Shift + F11 or Alt + Shift + F1
Shift + F11
Ctrl + Page Down
Control + Page Down or Option + →
Go to the previous worksheet
Ctrl + Page Up
Control + Page Up or Option + ←
Switch to the next open workbook
Ctrl + Tab
Cmd + `
Switch to the previous open workbook
Ctrl + Shift + Tab
Cmd + Shift + `
Minimize the workbook window
Ctrl + F9
Cmd + M
Maximize or restore the workbook window
Ctrl + F10
Control + F10
Ctrl + Shift + F1
Control + Cmd + F
Show or hide the ribbon
Ctrl + F1
Cmd + Option + R
Open Excel Options (Preferences on Mac)
Alt, F, T
Cmd + ,
Open Help
F1
Cmd + /
Move to the next pane (sheet, ribbon, task pane)
F6
F6
Move to the previous pane
Shift + F6
Shift + F6

Navigation Shortcuts

Use these to move around a sheet without the mouse. Ctrl + Arrow key is the one I use the most: it jumps to the last filled cell in that direction.

Action
Windows
Mac
Move one cell up, down, left or right
Arrow keys
Arrow keys
Move to the edge of the current data region
Ctrl + Arrow key
Cmd + Arrow key
Move one screen down
Page Down
Fn + ↓
Move one screen up
Page Up
Fn + ↑
Move one screen right
Alt + Page Down
Fn + Option + ↓
Move one screen left
Alt + Page Up
Fn + Option + ↑
Move to the beginning of the row
Home
Fn + ←
Move to cell A1
Ctrl + Home
Fn + Control + ←
Move to the last used cell
Ctrl + End
Fn + Control + →
Turn End mode on or off
End
Fn + →
Open the Go To dialog
Ctrl + G or F5
Control + G
Move one cell right (or to the next unlocked cell on a protected sheet)
Tab
Tab
Move one cell left
Shift + Tab
Shift + Tab
Scroll back to the active cell
Ctrl + Backspace
Control + Delete
Open a data validation or AutoComplete list
Alt + ↓
Option + ↓
Ctrl + Alt + =
Cmd + Option + +
Zoom out
Ctrl + Alt + -
Cmd + Option + -

Selection Shortcuts

Selecting a range with the keyboard is faster and more exact than dragging the mouse, especially on large data.

Action
Windows
Mac
Shift + Space
Shift + Space
Select the entire column
Ctrl + Space
Control + Space
Select the current region, then the whole sheet
Ctrl + A
Cmd + A
Select the current region around the active cell
Ctrl + Shift + *
Control + Shift + Space
Extend the selection by one cell
Shift + Arrow key
Shift + Arrow key
Extend the selection to the last non-blank cell
Ctrl + Shift + Arrow key
Cmd + Shift + Arrow key
Extend the selection down one screen
Shift + Page Down
Fn + Shift + ↓
Extend the selection up one screen
Shift + Page Up
Fn + Shift + ↑
Extend the selection right one screen
Alt + Shift + Page Down
Fn + Shift + Option + ↓
Extend the selection left one screen
Alt + Shift + Page Up
Fn + Shift + Option + ↑
Extend the selection to the start of the row
Shift + Home
Fn + Shift + ←
Extend the selection to cell A1
Ctrl + Shift + Home
Fn + Control + Shift + ←
Extend the selection to the last used cell
Ctrl + Shift + End
Fn + Control + Shift + →
Turn Extend mode on or off
F8
F8
Add more cells to the selection with the arrow keys
Shift + F8
Shift + F8
Add adjacent cells with the mouse
Shift + click
Shift + click
Add non-adjacent cells with the mouse
Ctrl + click
Cmd + click
Select only the active cell
Shift + Backspace
Shift + Delete
Move the active cell to the next corner of the selection
Ctrl + .
Control + .
Move to the next non-adjacent selection
Ctrl + Alt + →
Control + Option + →
Move to the previous non-adjacent selection
Ctrl + Alt + ←
Control + Option + ←
Select the same range in the next column
—
Option + Tab

Data Entry and Cell Editing Shortcuts

These shortcuts help you type, fill and edit data. Ctrl + Enter is worth remembering: type a value, press it, and Excel fills every selected cell with that value.

Action
Windows
Mac
F2
F2 or Control + U
Cancel the entry
Esc
Esc
Complete the entry and move down
Enter
Return
Complete the entry and move up
Shift + Enter
Shift + Return
Fill the selected cells with the current entry
Ctrl + Enter
Control + Return
Start a new line in the same cell
Alt + Enter
Control + Option + Return
Insert today's date
Ctrl + ;
Control + ;
Insert the current time
Ctrl + Shift + :
Cmd + ;
Ctrl + D
Control + D
Fill right from the cell on the left
Ctrl + R
Control + R
Copy the formula from the cell above
Ctrl + '
Control + '
Copy the value from the cell above
Ctrl + Shift + "
Control + Shift + "
Flash Fill
Ctrl + E
Control + E
Ctrl + K
Cmd + K
Shift + F2
Shift + F2
Insert a threaded comment
Ctrl + Shift + F2
Cmd + Shift + F2
Check spelling
F7
F7
Open the Thesaurus
Shift + F7
Shift + F7
Move one word left or right (while editing)
Ctrl + ← or Ctrl + →
Control + ← or Control + →
Select one word left or right (while editing)
Ctrl + Shift + ← or Ctrl + Shift + →
Control + Shift + ← or Control + Shift + →
Select to the start of the cell text
Shift + Home
Fn + Shift + ←
Select to the end of the cell text
Shift + End
Fn + Shift + →
Delete from the cursor to the end of the line
Ctrl + Delete
Fn + Control + Delete
Delete the character to the left of the cursor
Backspace
Delete
Delete the character to the right of the cursor
Delete
Fn + Delete

Copy, Paste, Undo and Find Shortcuts

The basics you use all day, plus Paste Special.

Action
Windows
Mac
Ctrl + C
Cmd + C
Ctrl + X
Cmd + X
Paste
Ctrl + V
Cmd + V
Open Paste Special
Ctrl + Alt + V
Cmd + Control + V
Ctrl + Shift + V
Cmd + Control + V, then choose Values
Ctrl + Z
Cmd + Z
Redo
Ctrl + Y
Cmd + Y or Cmd + Shift + Z
Repeat the last action
F4 or Ctrl + Y
Cmd + Y
Find
Ctrl + F
Cmd + F
Ctrl + H
Control + H
Find the next match (dialog closed)
Shift + F4
Cmd + G
Find the previous match (dialog closed)
Ctrl + Shift + F4
Cmd + Shift + G
Delete
Delete

After you open Paste Special with Ctrl + Alt + V on Windows, press one of these letters and then Enter:

Paste
Press
All
A
Formulas
F
Values
V
Formats
T
Comments and notes
C
Validation
N
All using source theme
H
All except borders
X
Column widths
W
Formulas and number formats
R
Values and number formats
U

Formatting Shortcuts

Use these to format text and align cells. On Windows, the ribbon shortcuts (like Alt, H, A, C) are pressed one key after another.

Action
Windows
Mac
Ctrl + 1
Cmd + 1
Open Format Cells with the Font tab selected
Ctrl + Shift + F
Control + Shift + F
Bold
Ctrl + B or Ctrl + 2
Cmd + B
Italic
Ctrl + I or Ctrl + 3
Cmd + I
Underline
Ctrl + U or Ctrl + 4
Cmd + U
Ctrl + 5
Cmd + Shift + X
Alt, H, A, C
Cmd + E
Align left
Alt, H, A, L
Cmd + L
Align right
Alt, H, A, R
Cmd + R
Alt, H, 6
Control + Option + Tab
Decrease the indent
Alt, H, 5
Control + Option + Shift + Tab
Increase the font size
Alt, H, F, G
Cmd + Shift + >
Decrease the font size
Alt, H, F, K
Cmd + Shift +
Alt, H, H
—
Open the borders menu
Alt, H, B
—
Open the Style dialog
Alt + '
Cmd + Shift + L

Number Format Shortcuts

Each of these applies a number format to the selected cells in one go. On a Mac, they use Control, not Cmd.

Action
Windows
Mac
General format
Ctrl + Shift + ~
Control + Shift + ~
Number format (two decimals, thousands separator)
Ctrl + Shift + !
Control + Shift + !
Ctrl + Shift + $
Control + Shift + $
Ctrl + Shift + %
Control + Shift + %
Scientific format (two decimals)
Ctrl + Shift + ^
Control + Shift + ^
Date format (day, month, year)
Ctrl + Shift + #
Control + Shift + #
Time format (hour, minute, AM/PM)
Ctrl + Shift + @
Control + Shift + @

Border Shortcuts

The first two work directly on the sheet. On Windows, the single-letter shortcuts work inside the Border tab of the Format Cells dialog (Ctrl + 1). On a Mac, the arrow shortcuts work directly on the sheet.

Action
Windows
Mac
Ctrl + Shift + &
Cmd + Option + 0
Remove all borders
Ctrl + Shift + _
Cmd + Option + _
Add or remove the right border
Alt + R
Cmd + Option + →
Add or remove the left border
Alt + L
Cmd + Option + ←
Add or remove the top border
Alt + T
Cmd + Option + ↑
Add or remove the bottom border
Alt + B
Cmd + Option + ↓
Add or remove the diagonal border
Alt + D
—
Add or remove the inside horizontal border
Alt + H
—
Add or remove the inside vertical border
Alt + V
—

Row, Column and Cell Shortcuts

Insert, delete, hide and group rows and columns with these.

Action
Windows
Mac
Ctrl + Shift + +
Control + Shift + =
Ctrl + -
Control + -
Hide the selected rows
Ctrl + 9
Control + 9
Hide the selected columns
Ctrl + 0
Control + 0
Unhide rows
Ctrl + Shift + 9
Control + Shift + 9
Ctrl + Shift + 0
Control + Shift + 0
Alt + Shift + →
Cmd + Shift + K
Ungroup rows or columns
Alt + Shift + ←
Cmd + Shift + J
Show or hide the outline symbols
Ctrl + 8
Control + 8
Delete the selected column (ribbon)
Alt, H, D, C
—

Formula Shortcuts

These shortcuts help you write, check and calculate formulas. In Microsoft 365, Excel 2024 and Excel 2021, you don't need Ctrl + Shift + Enter for array formulas anymore. Press Enter, and the result spills on its own.

Action
Windows
Mac
Alt + =
Cmd + Shift + T
F4
Cmd + T or F4
Open Insert Function
Shift + F3
Shift + F3
Open Function Arguments (after typing a function name)
Ctrl + A
Control + A
Insert argument names and parentheses
Ctrl + Shift + A
Control + Shift + A
Accept the function AutoComplete suggests
Tab
Tab
Ctrl + `
Control + `
Calculate all open workbooks
F9
F9
Calculate the active sheet
Shift + F9
Shift + F9
Force a full calculation of all sheets
Ctrl + Alt + F9
—
Evaluate the selected part of a formula
F9 (while editing)
F9 (while editing)
Expand or collapse the formula bar
Ctrl + Shift + U
Control + Shift + U
Open Name Manager
Ctrl + F3
Control + F3
Create names from row and column labels
Ctrl + Shift + F3
Control + Shift + F3
Paste a name into a formula
F3
F3
Define a name (ribbon)
Alt, M, M, D
—
Enter a legacy array formula
Ctrl + Shift + Enter
Control + Shift + Return

Go To Special Shortcuts

These select special cells in one go, like the cells a formula depends on or only the visible cells after you hide rows. Alt + ; is the one to remember when you copy filtered data.

Action
Windows
Mac
Select cells with comments
Ctrl + Shift + O
Fn + Control + Shift + O
Select the current array
Ctrl + /
Control + /
Select row differences
Ctrl +
Control +
Select column differences
Ctrl + Shift + |
Control + Shift + |
Select direct precedents
Ctrl + [
Control + [
Select all precedents
Ctrl + Shift + {
Control + Shift + {
Select direct dependents
Ctrl + ]
Control + ]
Select all dependents
Ctrl + Shift + }
Control + Shift + }
Select visible cells only
Alt + ;
Cmd + Shift + Z

Table, Filter and Pivot Table Shortcuts

Shortcuts for Excel tables, filters, Power Query and pivot tables.

Action
Windows
Mac
Create a table
Ctrl + T or Ctrl + L
Control + T
Ctrl + Shift + L
Cmd + Shift + F
Open the filter menu (on a header cell)
Alt + ↓
Option + ↓
Add or remove the table total row
Ctrl + Shift + T
Control + Shift + T
Clear a slicer filter
Alt + C
Option + C
Open the Custom Sort dialog
Alt, H, S, U
Cmd + Shift + R
Refresh all data connections
Ctrl + Alt + F5
—
Open the Power Query Editor
Alt + F12
Option + F12
Select the entire pivot table
Ctrl + A (inside it)
Cmd + A (inside it)
Group pivot table items
Alt + Shift + →
Cmd + Shift + K
Ungroup pivot table items
Alt + Shift + ←
Cmd + Shift + J
Hide the selected pivot table item
Ctrl + -
Control + -
Check or uncheck a field in the field list
Space
Space
Open the PivotTable wizard
Alt, D, P
Cmd + Option + P

Ribbon Shortcuts with the Alt Key (KeyTips)

Almost every command on the ribbon has a keyboard path, even when it has no Ctrl shortcut. Press Alt, and Excel shows a letter on each ribbon tab. These letters are called KeyTips.

Excel ribbon showing KeyTip letters on each tab after pressing Alt

Press the letter of a tab, and Excel shows the KeyTips for every command on that tab. Then press the letters one after another. For example, Alt, H, A, C centers the text in the selected cells.

KeyTips on the ribbon commands after pressing Alt and then the key for a tab
Action
Windows
Show KeyTips
Alt or F10
Go to the Search box
Alt + Q
Open the File tab
Alt + F
Open the Home tab
Alt + H
Open the Insert tab
Alt + N
Open the Page Layout tab
Alt + P
Open the Formulas tab
Alt + M
Open the Data tab
Alt + A
Open the Review tab
Alt + R
Open the View tab
Alt + W
Switch to Normal view
Alt, W, L
Switch to Page Layout view
Alt, W, P
Switch to Page Break Preview
Alt, W, I
Show the tooltip for the selected ribbon command
Ctrl + Shift + F10
Move between groups on the ribbon
Ctrl + ← or Ctrl + →
Open Paste Special with the old Excel 2003 menu keys
Alt, E, S

KeyTips are now in Excel for Microsoft 365 on a Mac too. Turn them on from Excel > Preferences, and then press Option to show them.

Function Key Shortcuts (F1 to F12)

Here is what each function key does on its own and with Shift, Ctrl and Alt in Excel for Windows. For the Mac keys, use the tables above.

Key
Alone
With Shift
With Ctrl
With Alt
F1
Open Help
Show or hide the ribbon
Create a chart
F2
Edit the active cell
Insert or edit a note
Edit in the formula bar
F3
Paste a name
Open Insert Function
Open Name Manager
Go to the Name Box
F4
Repeat the last action, or switch references
Find the next match
Close the workbook window
Close Excel
F5
Open Go To
Restore the window size
F6
Move to the next pane
Move to the previous pane
Switch to the next workbook window
F7
Check spelling
Open the Thesaurus
Move the window
F8
Turn Extend mode on or off
Add to the selection
Resize the window
Open the Macro dialog
F9
Calculate all open workbooks
Calculate the active sheet
Minimize the window
F10
Turn KeyTips on or off
Open the right-click menu
Maximize or restore the window
F11
Create a chart on a new sheet
Insert a new worksheet
Open the VBA Editor
F12
Open Save As
Open the Power Query Editor

Other Useful Shortcuts

Drag-and-drop tricks, charts, macros, objects and dialog boxes.

Action
Windows
Mac
Copy cells by dragging
Ctrl + drag
Option + drag
Move and insert cells by dragging
Shift + drag
Shift + drag
Insert a copy of cells by dragging
Ctrl + Shift + drag
Option + Shift + drag
Drag cells to another sheet
Alt + drag
Cmd + drag
Duplicate a worksheet
Ctrl + drag the sheet tab
Option + drag the sheet tab
Create a chart of the selected data
Alt + F1
Option + F1
Create a chart on a new sheet
F11
F11
Show Quick Analysis
Ctrl + Q
—
Open the Macro dialog
Alt + F8
Option + F8
Open the VBA Editor
Alt + F11
Option + F11
Open the right-click menu
Shift + F10
Shift + F10
Hide or show objects
Ctrl + 6
Control + 6
Duplicate the selected object
Ctrl + D
Cmd + D
Snap an object to the grid while dragging
Alt + drag
Cmd + drag
Turn Scroll Lock on or off
ScrLk
Shift + F14
Open the Excel window menu
Alt + Space
—
Dialog box: move to the next option
Tab
Tab
Dialog box: move to the previous option
Shift + Tab
Shift + Tab
Dialog box: move to the next tab
Ctrl + Tab
Control + Tab
Dialog box: move to the previous tab
Ctrl + Shift + Tab
Control + Shift + Tab
Dialog box: check or uncheck a box
Space
Space
Dialog box: close without changes
Esc
Esc

Less-Known Excel Shortcuts

These five don't get much attention, but I use them all the time.

  1. Ctrl + Q: opens Quick Analysis for the selected data, so you can add formatting, charts, totals or a table in two clicks.
  2. Ctrl + `: shows the formulas in every cell instead of their results. Press it again to switch back.
  3. Ctrl + ; and Ctrl + Shift + :: insert today's date and the current time as fixed values that don't change later.
  4. Shift + F3: opens the Insert Function dialog, where you can search for a function and fill in its arguments.
  5. Ctrl + Shift + O: selects every cell on the sheet that has a comment.

Frequently Asked Questions

What does F4 do in Excel?

F4 has two jobs. When you are not editing a cell, it repeats your last action, like applying the same fill color to another cell. When you are editing a formula and the cursor is on a cell reference, it switches the reference from A1 to $A$1, A$1, $A1 and back to A1. On a Mac, press Cmd + T to switch references (F4 also works in Excel for Microsoft 365) and Cmd + Y to repeat the last action.

Do Windows Excel shortcuts work on a Mac?

Many of them do when you press Cmd in place of Ctrl, like Cmd + C, Cmd + V, Cmd + S and Cmd + B. But a lot of them are different. For example, turning filters on and off is Cmd + Shift + F on a Mac, and the number format shortcuts use Control, not Cmd. That's why every table on this page has a separate Mac column. On a MacBook, you may also need to hold Fn for the F1 to F12 keys.

How can I find the shortcut for any Excel command?

On Windows, press Alt, and Excel shows a KeyTip letter on every ribbon tab. Press a tab's letter to see the KeyTips for its commands. You can also hover the mouse over a ribbon button: when the command has a shortcut, the ScreenTip shows it next to the command name.

Can I create my own keyboard shortcut in Excel?

Yes. On Windows, add the command to the Quick Access Toolbar. Excel gives the first nine buttons on it the shortcuts Alt + 1 to Alt + 9, in the order they appear. For a macro, open Alt + F8, select the macro, click Options and set a Ctrl shortcut. On a Mac, go to Tools > Customize Keyboard, select the command and press the keys you want to use.

Why is my Excel shortcut not working?

Most of the time, it's one of three things. First of all, on many laptops the F1 to F12 keys control things like brightness and volume, so hold Fn with them (or turn on Fn Lock if your keyboard has one). After that, check whether another app or the system uses the same keys. For example, on a Mac Control + Space switches the input source by default, so it won't select a column until you change that in System Settings > Keyboard > Keyboard Shortcuts. In the end, the shortcuts on this page are for the US keyboard layout, and some keys sit in different places on other layouts.