Excel Shortcuts – Get Things Done Faster in Excel!

Are you always searching for ways to work faster in Excel? Well, look no further!

On this page, I am sharing some of my favorite Excel shortcuts that will help you get things done in a snap.

From quickly inserting rows and columns to navigating your worksheet with ease, these shortcuts will help you save time and boost your productivity.

So whether you’re a beginner or an experienced Excel user, be sure to check out our list of essential keyboard shortcuts. You won’t regret it!

1. File and Workbook Management Shortcuts

Action	Windows Shortcut	Mac Shortcut
Create the new workbook	`Ctrl` + `N`	`Cmd` + `N`
Open workbook	`Ctrl` + `O`	`Cmd` + `O`
Save workbook	`Ctrl` + `S`	`Cmd` + `S`
Save As	`F12`	`Cmd` + `Shift` + `S`
Print	`Ctrl` + `P`	`Cmd` + `P`
Open Print Preview	`Ctrl` + `F2`	`Cmd` + `P`
Close the current workbook	`Ctrl` + `W`	`Cmd` + `W`
Close Excel	`Alt` + `F4`	`Cmd` + `Q`

2. Navigation Shortcuts

Action	Windows Shortcut	Mac Shortcut
Move one cell up / down / left / right	Arrow Keys	Arrow Keys
Move to the edge of the data region	`Ctrl` + Arrow Key	`Cmd` + Arrow Key
Move to the beginning of the row	`Home`	`Fn` + `Left Arrow`
Move to the first cell in the worksheet (A1)	`Ctrl` + `Home`	`Fn` + `Ctrl` + `Left Arrow`
Move to the last used cell in the worksheet	`Ctrl` + `End`	`Fn` + `Ctrl` + `Right Arrow`
Move one screen down	`Page Down`	`Fn` + `Down Arrow`
Move one screen up	`Page Up`	`Fn` + `Up Arrow`
Go to the next worksheet	`Ctrl` + `Page Down`	`Option` + `Right Arrow`
Go to the previous worksheet	`Ctrl` + `Page Up`	`Option` + `Left Arrow`
Switch to the next workbook	`Ctrl` + `Tab`	`Cmd` + `
Switch to the previous workbook	`Ctrl` + `Shift` + `Tab`	`Cmd` + `Shift` + `
Open the Go To dialog box	`Ctrl` + `G`	`Ctrl` + `G`

3. Selection Shortcuts

Action	Windows Shortcut	Mac Shortcut
Select entire row	`Shift` + `Space`	`Shift` + `Space`
Select entire column	`Ctrl` + `Space`	`Ctrl` + `Space`
Select entire worksheet	`Ctrl` + `A`	`Cmd` + `A`
Extend selection by one cell	`Shift` + Arrow Key	`Shift` + Arrow Key
Extend selection to edge of data region	`Ctrl` + `Shift` + Arrow Key	`Cmd` + `Shift` + Arrow Key
Extend selection to start of row	`Shift` + `Home`	`Fn` + `Shift` + `Left Arrow`
Extend selection to first cell in worksheet	`Ctrl` + `Shift` + `Home`	`Fn` + `Ctrl` + `Shift` + `Left Arrow`
Extend selection to last used cell	`Ctrl` + `Shift` + `End`	`Fn` + `Ctrl` + `Shift` + `Right Arrow`
Select current region around active cell	`Ctrl` + `Shift` + `*`	`Ctrl` + `Shift` + `Space`
Select visible cells only	`Alt` + `;`	`Cmd` + `Shift` + `Z`
Add non-adjacent cells to selection	`Ctrl` + Click	`Cmd` + Click

4. Editing and Data Entry Shortcuts

Action	Windows Shortcut	Mac Shortcut
Edit the active cell	`F2`	`Ctrl` + `U`
Cancel entry	`Esc`	`Esc`
Enter and move down	`Enter`	`Return`
Enter and move up	`Shift` + `Enter`	`Shift` + `Return`
Enter and move right	`Tab`	`Tab`
Enter same data in multiple selected cells	`Ctrl` + `Enter`	`Ctrl` + `Return`
Insert line break within a cell	`Alt` + `Enter`	`Ctrl` + `Option` + `Return`
Delete cell contents	`Delete`	`Fn` + `Delete`
Insert current date	`Ctrl` + `;`	`Ctrl` + `;`
Insert current time	`Ctrl` + `Shift` + `:`	`Cmd` + `;`
Fill down from cell above	`Ctrl` + `D`	`Cmd` + `D`
Fill right from cell to the left	`Ctrl` + `R`	`Cmd` + `R`
Copy formula from cell above	`Ctrl` + `'`	`Cmd` + `'`
Copy value from cell above	`Ctrl` + `Shift` + `"`	`Ctrl` + `Shift` + `"`
Display AutoComplete list	`Alt` + `Down Arrow`	`Option` + `Down Arrow`
Flash Fill	`Ctrl` + `E`	`Ctrl` + `E`
Add hyperlink	`Ctrl` + `K`	`Cmd` + `K`

5. Copy, Paste and Undo Shortcuts

Action	Windows Shortcut	Mac Shortcut
Copy	`Ctrl` + `C`	`Cmd` + `C`
Cut	`Ctrl` + `X`	`Cmd` + `X`
Paste	`Ctrl` + `V`	`Cmd` + `V`
Paste Values	`Ctrl` + `Shift` + `V`	`Cmd` + `Shift` + `V`
Open Paste Special dialog box	`Ctrl` + `Alt` + `V`	`Cmd` + `Ctrl` + `V`
Undo	`Ctrl` + `Z`	`Cmd` + `Z`
Redo	`Ctrl` + `Y`	`Cmd` + `Y`
Repeat last action	`F4`	`Cmd` + `Y`

6. Formatting Shortcuts

Action	Windows Shortcut	Mac Shortcut
Open Format Cells dialog box	`Ctrl` + `1`	`Cmd` + `1`
Bold	`Ctrl` + `B`	`Cmd` + `B`
Italic	`Ctrl` + `I`	`Cmd` + `I`
Underline	`Ctrl` + `U`	`Cmd` + `U`
Strikethrough	`Ctrl` + `5`	`Cmd` + `Shift` + `X`
Align left	`Alt`, `H`, `A`, `L`	`Cmd` + `L`
Align center	`Alt`, `H`, `A`, `C`	`Cmd` + `E`
Align right	`Alt`, `H`, `A`, `R`	`Cmd` + `R`
Increase font size	`Alt`, `H`, `F`, `G`	`Cmd` + `Shift` + `>`
Decrease font size	`Alt`, `H`, `F`, `K`	`Cmd` + `Shift` + `<`
Indent	`Alt`, `H`, `6`	`Ctrl` + `Option` + `Tab`
Remove indent	`Alt`, `H`, `5`	`Ctrl` + `Option` + `Shift` + `Tab`
Merge and Center cells	`Alt`, `H`, `M`, `C`	No direct shortcut
Wrap Text	`Alt`, `H`, `W`	No direct shortcut
Apply Fill Color	`Alt`, `H`, `H`	No direct shortcut
Format Painter (copy formatting)	`Alt`, `H`, `F`, `P`	No direct shortcut
Autofit Column Width	`Alt`, `H`, `O`, `I`	No direct shortcut

7. Number Formatting Shortcuts

Action	Windows Shortcut	Mac Shortcut
Apply General format	`Ctrl` + `Shift` + `~`	`Ctrl` + `Shift` + `~`
Apply Currency format	`Ctrl` + `Shift` + `$`	`Ctrl` + `Shift` + `$`
Apply Percentage format	`Ctrl` + `Shift` + `%`	`Ctrl` + `Shift` + `%`
Apply Scientific (exponential) format	`Ctrl` + `Shift` + `^`	`Ctrl` + `Shift` + `^`
Apply Date format	`Ctrl` + `Shift` + `#`	`Ctrl` + `Shift` + `#`
Apply Time format	`Ctrl` + `Shift` + `@`	`Ctrl` + `Shift` + `@`
Apply Number format (two decimals, thousands separator)	`Ctrl` + `Shift` + `!`	`Ctrl` + `Shift` + `!`

8. Borders Shortcuts

Action	Windows Shortcut	Mac Shortcut
Add outline border	`Ctrl` + `Shift` + `&`	`Cmd` + `Option` + `0`
Remove all borders	`Ctrl` + `Shift` + `_`	`Cmd` + `Option` + `_`

9. Rows, Columns, and Cells Shortcuts

Action	Windows Shortcut	Mac Shortcut
Insert cells / rows / columns	`Ctrl` + `Shift` + `+`	`Cmd` + `Shift` + `+`
Delete cells / rows / columns	`Ctrl` + `-`	`Cmd` + `-`
Hide selected columns	`Ctrl` + `0`	`Ctrl` + `0`
Unhide selected columns	`Ctrl` + `Shift` + `0`	`Ctrl` + `Shift` + `0`
Hide selected rows	`Ctrl` + `9`	`Ctrl` + `9`
Unhide selected rows	`Ctrl` + `Shift` + `9`	`Ctrl` + `Shift` + `9`
Group rows or columns	`Alt` + `Shift` + `Right Arrow`	`Cmd` + `Shift` + `K`
Ungroup rows or columns	`Alt` + `Shift` + `Left Arrow`	`Cmd` + `Shift` + `J`
Show or hide outline symbols	`Ctrl` + `8`	`Ctrl` + `8`

10. Formulas Shortcuts

Action	Windows Shortcut	Mac Shortcut
Toggle between absolute and relative references	`F4`	`Cmd` + `T`
Insert AutoSum formula	`Alt` + `=`	`Cmd` + `Shift` + `T`
Toggle formulas on and off	`Ctrl` + `	`Ctrl` + `
Open Insert Function dialog box	`Shift` + `F3`	`Fn` + `Shift` + `F3`
Enter array formula	`Ctrl` + `Shift` + `Enter`	`Ctrl` + `Shift` + `Return`
Calculate all worksheets	`F9`	`Fn` + `F9`
Calculate active worksheet only	`Shift` + `F9`	`Fn` + `Shift` + `F9`

11. Tables and Filters Shortcuts

Action	Windows Shortcut	Mac Shortcut
Insert Table	`Ctrl` + `T`	`Cmd` + `T`
Apply / Remove Filters	`Ctrl` + `Shift` + `L`	`Cmd` + `Shift` + `F`
Open/activate filter dropdown	`Alt` + `Down Arrow`	`Option` + `Down Arrow`

12. Worksheet and Workbook Management Shortcuts

Action	Windows Shortcut	Mac Shortcut
Insert new worksheet	`Shift` + `F11`	`Fn` + `Shift` + `F11`
Delete current sheet	`Alt`, `H`, `D`, `S`	No direct shortcut
Freeze Panes	`Alt`, `W`, `F`, `F`	No direct shortcut
Select adjacent worksheets	`Shift` + Click on tab	`Shift` + Click on tab
Toggle full screen	`Ctrl` + `Shift` + `F1`	`Ctrl` + `Cmd` + `F`
Expand or collapse Ribbon	`Ctrl` + `F1`	`Cmd` + `Option` + `R`

13. Find and Replace Shortcuts

Action	Windows Shortcut	Mac Shortcut
Open Find	`Ctrl` + `F`	`Cmd` + `F`
Open Find and Replace (Replace tab)	`Ctrl` + `H`	`Ctrl` + `H`
Find next match	`Shift` + `F4`	`Cmd` + `G`
Find previous match	`Ctrl` + `Shift` + `F4`	`Cmd` + `Shift` + `G`

14. Charts and Objects Shortcuts

Action	Windows Shortcut	Mac Shortcut
Create embedded chart from selected data	`Alt` + `F1`	`Fn` + `Option` + `F1`
Create chart in new worksheet	`F11`	`Fn` + `F11`
Hide or show objects	`Ctrl` + `6`	`Ctrl` + `6`

15. Comments and Notes Shortcuts

Action	Windows Shortcut	Mac Shortcut
Insert or edit note	`Shift` + `F2`	`Fn` + `Shift` + `F2`
Insert threaded comment	`Ctrl` + `Shift` + `F2`	`Fn` + `Cmd` + `Shift` + `F2`
Delete comment	`Shift` + `F10`, then `D`	`Fn` + `Shift` + `F10`, then `D`

16. Zoom and View Shortcuts

Action	Windows Shortcut	Mac Shortcut
Zoom in	`Ctrl` + `Alt` + `=`	`Option` + `Cmd` + `=`
Zoom out	`Ctrl` + `Alt` + `-`	`Option` + `Cmd` + `-`
Zoom with scroll wheel	`Ctrl` + Scroll	`Ctrl` + Scroll

17. Auditing and Selecting Special Cells Shortcuts

Action	Windows Shortcut	Mac Shortcut
Select direct precedents	`Ctrl` + `[`	`Ctrl` + `[`
Select direct dependents	`Ctrl` + `]`	`Ctrl` + `]`

18. VBA, Macros and Other Tools Shortcuts

Action	Windows Shortcut	Mac Shortcut
Open VBA Editor	`Alt` + `F11`	`Fn` + `Option` + `F11`
Open Macro dialog box	`Alt` + `F8`	`Fn` + `Option` + `F8`
Check spelling	`F7`	`Fn` + `F7`
Display right-click (context) menu	`Shift` + `F10`	`Fn` + `Shift` + `F10`
Open Excel Options	`Alt`, `F`, `T`	`Cmd` + `,`
Open Help	`F1`	`Cmd` + `/`

All articles about useful Excel keyboard Shortcuts:

Other articles you may also like: