Essential Microsoft Excel Shortcuts

In this article we list some of the top Microsoft Excel shortcuts that will help you navigate Excel more easily.

Keyboard shortcuts can really improve productivity for frequent users of Microsoft Excel. This article runs through some of the top shortcuts you’ll find helpful.

Navigating a workbook

Move to the top or bottom cell of current area	Ctrl + up/down arrow
Move to the next non-blank cell in a row	Control + left/right arrow
Previous/next worksheet	Ctrl+Page Up/Page Down
Go To specific cell reference	Ctrl+G
Jump to cell A1/first non-frozen cell	Ctrl+Home
Jump to last used cell	Ctrl+End

Selecting cells

All cells containing data above or below the current cell	Ctrl+Shift+up/down arrow
All cells containing data to the left or right of the current cell	Ctrl+Shift+left/right arrow
All cells in a current region	Ctrl+Shift+8
Current column	Ctrl+Space
Current row	Shift+Space

Working with worksheets

Add new worksheet	Shift+F11
Duplicate worksheet	Hold Ctrl+drag sheet left or right
Move data to another sheet	Hold Alt+drag data to another sheet
Insert row/column (depending on selection)	Ctrl + (or Ctrl+Shift =)
Delete row/column (depending on selection)	Ctrl -
Group consecutive worksheets	Click first; Shift+click last
Group non-consecutive worksheets	Click first; Ctrl+click next

Working with data

Open cell for editing	F2
AutoSum numbers before current cell	Alt=
Add/remove filters	Ctrl+Shift+L
Insert current date (static)	Ctrl ;
Insert current time (static)	Ctrl+Shift ;

Formatting data

Open cell for editing	F2
AutoSum numbers before current cell	Alt=
Add/remove filters	Ctrl+Shift+L
Insert current date (static)	Ctrl ;
Insert current time (static)	Ctrl+Shift ;