Hotkeys – Navigate Spreadsheets (no mouse)


Useful Microsoft Excel hotkeys to have in your back pocket

  • Use Microsoft Excel faster
  • Navigate spreadsheets with no mouse

 

HotkeyWhat it doesHow to use it
Ctrl + SSave workbook.1. Press 'Ctrl' and hold the key
2. Press 'S' once
3. Let go of the 'Ctrl' key
Ctrl + PPrint workbook.1. Press 'Ctrl' and hold the key
2. Press 'P' once
3. Let go of the 'Ctrl' key
Ctrl + NCreate new workbook.1. Press 'Ctrl' and hold the key
2. Press 'N' once
3. Let go of the 'Ctrl' key
Ctrl + CCopy1. Press 'Ctrl' and hold the key
2. Press 'C' once
3. Let go of the 'Ctrl' key
Ctrl + XCut1. Press 'Ctrl' and hold the key
2. Press 'X' once
3. Let go of the 'Ctrl' key
Ctrl + VPaste1. Press 'Ctrl' and hold the key
2. Press 'V' once
3. Let go of the 'Ctrl' key
Ctrl + ZUndo1. Press 'Ctrl' and hold the key
2. Press 'Z' once
3. Let go of the 'Ctrl' key
Ctrl + YRedo1. Press 'Ctrl' and hold the key
2. Press 'Y' once
3. Let go of the 'Ctrl' key
Ctrl + BBold1. Press 'Ctrl' and hold the key
2. Press 'B' once
3. Let go of the 'Ctrl' key
Ctrl + IItalics1. Press 'Ctrl' and hold the key
2. Press 'I' once
3. Let go of the 'Ctrl' key
Ctrl + UUnderline1. Press 'Ctrl' and hold the key
2. Press 'U' once
3. Let go of the 'Ctrl' key
Double-click on the 'Format Painter'Allows you to apply formatting to multiple cells (or rows or columns).1. Select a cell (or a row or a column) which has the formatting you want to apply to other places
2. Go to 'HOME' tab
3. Double-click on 'Format Painter'
4. Click on the multiple cells (or rows or columns) you want to apply the formatting to
5. Press 'ESC' to release
F2Enter 'Edit mode' of the active cell.1. Click on the cell you want to edit
2. Press 'F2' once
3. Make your changes and press 'Enter'
F4Toggle between various Absolute Reference types.

View the link for more details on how to use the hotkey.
1. Press F4 once (absolute reference on both row and column)
2. Press F4 again (absolute reference on row only)
3. Press F4 again (absolute reference on column only)
4. Press F4 again (back to relative reference)

Note: Instead of using F4, you can also manually type the $ symbol in front of the rows / columns as required.
F9Recalculate entire workbook (all tabs) if you set 'Calculation Options' to 'Manual' to stop Microsoft Excel from automatically recalculating all the time.

Note: This feature is available in the "FORMULAS" tab.
1. Press 'F9' once
Shift + F9Recalculate active worksheet (current tab) if you set 'Calculation Options' to 'Manual' to stop Microsoft Excel from automatically recalculating all the time.

Note: This feature is available in the "FORMULAS" tab.
1. Press 'Shift' and hold the key
2. Press 'F9' once
3. Let go of the 'Shift' key
Alt + =Auto Sum1. Press 'Alt' and hold the key
2. Press '=' once
3. Let go of the 'Alt' key
Alt + E + S + VPaste Special values (to get rid of formulas)1. Make sure you have a cell (or range) copied
2. Select the cell you want to 'paste special values' into (or you can paste into the same cell that you are copying from)
3. Press 'Alt' once
4. Press 'E' once
5. Press 'S' once
6. Press 'V' once
7. Press 'Enter' or click 'OK'
Ctrl + Shift + LAdd data filters1. Have your data range selected that you want to apply filters to
2. Press 'Ctrl' and hold the key
3. Press 'Shift' and hold the key
4. Press 'L' once
5. Let go of the 'Ctrl' and 'Shift' keys
Ctrl + 'Page Up'Travel up the different worksheets (towards the left) if your workbook has multiple tabs.1. Press 'Ctrl' and hold the key
2. Press 'Page Up' once
3. Let go of the 'Ctrl' key
Ctrl + 'Page Down'Travel down the different worksheets (towards the right) if your workbook has multiple tabs.1. Press 'Ctrl' and hold the key
2. Press 'Page Down' once
3. Let go of the 'Ctrl' key
Ctrl + any arrow key (left, right, up, down)Spreadsheet Navigation - Travel directly to the last value within a range of data in the direction you select (depending on the arrow key you use)1. Press 'Ctrl' and hold the key
2. Press an arrow key once
3. Let go of the 'Ctrl' key

Note: if you have blanks (empty cells) breaking up your data you will be stopped at the 1st break. You can continue traversing your range by continuing to tap the arrow key while holding 'Ctrl'.
Shift + Ctrl + any arrow key (left, right, up, down)Highlight cells (entire row or column in 1 shot) beginning from the active cell directly to the last value in the direction you select (depending on the arrow key you use)1. Press 'Shift' and hold the key
2. Press 'Ctrl' and hold the key
3. Press an arrow key once
4. Let go of the 'Shift' and 'Ctrl' keys

Note: While holding 'Shift' and 'Ctrl' you can press multiple arrow keys to select multiple rows and columns (not just a single row or single column).
Shift + any arrow key (left, right, up, down)Highlight cells (1 at a time) beginning from the active cell.1. Press 'Shift' and hold the key
3. Press an arrow key once
4. Let go of the 'Shift' key

Note: While holding 'Shift' you can press multiple arrow keys to select multiple rows and columns (not just a single row or single column).

 

Go back to Excel Tutorials.