Last Updated: May 26, 2024
82 Keyboard Shortcuts for Excel YOU Need + (PDF Cheat Sheet)
Knowing and using Keyboard Shortcuts is one of those Excel Skills that can help you save a ton of time every day. There are more than 500 keyboard shortcuts that you can use in Excel, but the problem is not all of those can be helpful for you.
That’s why I have listed only the 82 most important keyboard shortcuts that you can learn and use easily. If somehow you are not able to find a keyboard shortcut for the option that you use frequently in your work, you can use the following method to find it.
Most Amazing Keyboard Shortcuts for Excel
Navigation
- Move to edge of data region
- Windows: Ctrl + Arrow Keys
- Mac: Command + Arrow Keys
- Move to beginning of worksheet
- Windows: Ctrl + Home
- Mac: Command + Home
- Move to last cell with content
- Windows: Ctrl + End
- Mac: Command + End
- Go to a specific cell
- Windows: Ctrl + G or F5
- Mac: Command + G or F5
- Show active cell
- Windows: Ctrl + Backspace
- Mac: Command + Delete
Formatting
- Open Format Cells dialog box
- Windows: Ctrl + 1
- Mac: Command + 1
- Bold
- Windows: Ctrl + B
- Mac: Command + B
- Italic
- Windows: Ctrl + I
- Mac: Command + I
- Underline
- Windows: Ctrl + U
- Mac: Command + U
- Strikethrough
- Windows: Ctrl + 5
- Mac: Command + Shift + X
- Change cell fill color
- Windows: Alt + H, H
- Mac: Option + Command + H
- No fill
- Windows: Alt + H, H, N
- Mac: Option + Command + H, N
- More colors
- Windows: Alt + H, H, M
- Mac: Option + Command + H, M
- Change font color
- Windows: Alt + H, FC
- Mac: Option + Command + C
- Center align cell contents
- Windows: Alt + H, AC
- Mac: Option + Command + C
- Left align cell contents
- Windows: Alt + H, AL
- Mac: Option + Command + L
- Right align cell contents
- Windows: Alt + H, AR
- Mac: Option + Command + R
- Add border
- Windows: Alt + H, B
- Mac: Option + Command + B
- AutoFit column width
- Windows: Alt + H, O, I
- Mac: Option + Command + I
- Apply currency format
- Windows: Ctrl + Shift + $
- Mac: Command + Shift + $
- Apply percentage format
- Windows: Ctrl + Shift + %
- Mac: Command + Shift + %
- Apply scientific format
- Windows: Ctrl + Shift + ^
- Mac: Command + Shift + ^
- Apply date format
- Windows: Ctrl + Shift + #
- Mac: Command + Shift + #
- Apply time format
- Windows: Ctrl + Shift + @
- Mac: Command + Shift + @
Formulas
- Start a formula
- Windows: =
- Mac: =
- AutoSum
- Windows: Alt + =
- Mac: Command + Shift + T
- Toggle formula view
- Windows: Ctrl + `
- Mac: Command + `
- Insert a function
- Windows: Shift + F3
- Mac: Shift + F3
- Trace precedents
- Windows: Ctrl + [
- Mac: Command + [
- Trace dependents
- Windows: Ctrl + ]
- Mac: Command + ]
- Calculate active worksheet
- Windows: Shift + F9
- Mac: Shift + F9
- Calculate all worksheets
- Windows: F9
- Mac: F9
Miscellaneous
- Open Help
- Windows: F1
- Mac: Command + /
- Insert chart
- Windows: Alt + F1
- Mac: F11
- Insert chart in a new sheet
- Windows: F11
- Mac: Fn + F11
- New worksheet
- Windows: Shift + F11
- Mac: Shift + Fn + F11
- Hide rows
- Windows: Ctrl + 9
- Mac: Command + 9
- Unhide rows
- Windows: Ctrl + Shift + 9
- Mac: Command + Shift + 9
- Hide columns
- Windows: Ctrl + 0
- Mac: Command + 0
- Unhide columns
- Windows: Ctrl + Shift + 0
- Mac: Command + Shift + 0
- Create table
- Windows: Ctrl + T
- Mac: Command + T
- Apply outline border
- Windows: Ctrl + Shift + &
- Mac: Command + Shift + &
- Remove outline border
- Windows: Ctrl + Shift + _
- Mac: Command + Shift + _
- AutoFit column width
- Windows: Alt + H, O, I
- Mac: Option + Command + I
- Apply currency format
- Windows: Ctrl + Shift + $
- Mac: Command + Shift + $
- Apply percentage format
- Windows: Ctrl + Shift + %
- Mac: Command + Shift + %
- Apply scientific format
- Windows: Ctrl + Shift + ^
- Mac: Command + Shift + ^
- Apply date format
- Windows: Ctrl + Shift + #
- Mac: Command + Shift + #
- Apply time format
- Windows: Ctrl + Shift + @
- Mac: Command + Shift + @
- Fill down
- Windows: Ctrl + D
- Mac: Command + D
- Fill right- Windows: Ctrl + R - Mac: Command + R
Selection
- Select entire column
- Windows: Ctrl + Space
- Mac: Command + Space
- Select entire row
- Windows: Shift + Space
- Mac: Shift + Space
- Select entire worksheet
- Windows: Ctrl + A
- Mac: Command + A
- Extend selection in direction
- Windows: Shift + Arrow Keys
- Mac: Shift + Arrow Keys
- Select to the edge of data
- Windows: Ctrl + Shift + Arrow Keys
- Mac: Command + Shift + Arrow Keys
- Extend selection to start
- Windows: Ctrl + Shift + Home
- Mac: Command + Shift + Home
- Extend selection to end
- Windows: Ctrl + Shift + End
- Mac: Command + Shift + End
- Extend selection up one screen
- Windows: Shift + Page Up
- Mac: Shift + Fn + Up Arrow
- Extend selection down one screen
- Windows: Shift + Page Down
- Mac: Shift + Fn + Down Arrow
- Select the entire worksheet
- Windows: Ctrl + Shift + Space
- Mac: Command + Shift + Space
Data
- Edit active cell
- Windows: F2
- Mac: Control + U
- Copy
- Windows: Ctrl + C
- Mac: Command + C
- Cut
- Windows: Ctrl + X
- Mac: Command + X
- Paste
- Windows: Ctrl + V
- Mac: Command + V
- Undo
- Windows: Ctrl + Z
- Mac: Command + Z
- Redo
- Windows: Ctrl + Y
- Mac: Command + Y
- Clear cell contents
- Windows: Delete
- Mac: Delete
- Paste Special
- Windows: Alt + E, S, V
- Mac: Command + Control + V
- Fill down
- Windows: Ctrl + D
- Mac: Command + D
- Fill right
- Windows: Ctrl + R
- Mac: Command + R
- Insert cells, rows, columns
- Windows: Ctrl + Shift + Plus (+)
- Mac: Command + Shift + Plus (+)
- Delete cells, rows, columns
- Windows: Ctrl + Minus (-)
- Mac: Command + Minus (-)
- Insert a hyperlink
- Windows: Ctrl + K
- Mac: Command + K
- Delete hyperlink
- Windows: Alt + A, R, H
- Mac: Option + Command + R, H
- Insert argument names into formula
- Windows: Ctrl + Shift + A
- Mac: Command + Shift + A
Workbook Management
- New workbook
- Windows: Ctrl + N
- Mac: Command + N
- Open workbook
- Windows: Ctrl + O
- Mac: Command + O
- Save workbook
- Windows: Ctrl + S
- Mac: Command + S
- Print workbook
- Windows: Ctrl + P
- Mac: Command + P
- Close workbook
- Windows: Ctrl + W
- Mac: Command + W
- Save As
- Windows: F12
- Mac: Command + Shift + S
- Print preview
- Windows: Ctrl + F2
- Mac: Command + P
- Exit Excel
- Windows: Alt + F4
- Mac: Command + Q
Helpful Note
When you press the ALT key Excel shows you the keys that you can use to open the tab from the ribbon.
And when you press a key for a particular tab to open it further shows you the keys to open the options that you have on that tab, so one for further dropdowns.
Some Less Known Excel Shortcuts
Using keyboard shortcuts can speed up your workflow and make you more efficient. Here are some amazing keyboard shortcuts that I have learned throughout the years.
- Quick Analysis Tool - After selecting a range of cells, press Ctrl + Q to open the Quick Analysis tool. This tool offers options for formatting charts, totals, tables, and sparklines tailored to the selected data.
- Toggle Formulas View - Press Ctrl + ` to toggle between displaying formulas and their results in cells. It is handy for quickly reviewing the formulas in a worksheet.
- Insert Current Date and Time - Ctrl + ; (semicolon) inserts the current date into a cell, and Ctrl + Shift + ; inserts the current time. This is especially entertaining for timestamps in a cell.
- Open Insert Function Dialog - Press Shift + F3 to open the Insert Function dialog box. This box allows you to search for and insert functions without typing them manually or remembering syntax.
- Select All Cells with Comments - Press Ctrl + Shift + O (the letter O) to select all cells that have comments. This is handy when quickly navigating through or editing comments in a worksheet.
More Excel Keyboard Shortcuts
More Tutorials for You
Written by Puneet for Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, and Excel 365