Useful Excel Keyboard Shortcuts
Boost your productivity and complete your tasks effortlessly with these clearly illustrated 230+ Useful Excel Keyboard Shortcuts —your ticket to working faster and more efficiently! 🚀
General Shortcuts
- Open help:
F1
- Undo last action:
Ctrl + Z
- Redo last action:
Ctrl + Y
- Copy selection:
Ctrl + C
- Repeat last action:
F4
- Cut selection:
Ctrl + X
- Paste content from clipboard:
Ctrl + V
- Display Paste Special dialog box:
Ctrl + Alt + V
- Display find and replace with Find tab selected:
Ctrl + F
- Display find and replace with Replace tab selected:
Ctrl + H
- Find Previous Match (after initial Find): Shift + F4
- Find Previous Match (after initial Find): Shift + F4
- Find Next Match (after initial Find): Ctrl + F4
- Insert Embedded Chart: Alt + F1
- Insert Chart in New Sheet: F11
- Toggle Autofilter: Ctrl + Shift + L
- Activate Filter: Alt + ↓
- Create Table: Ctrl + T
- Select Table Row: Shift + Space
- Select Table Column: Ctrl + Space
- Select Table (when active cell is in table): Ctrl + A
- Clear Slicer Filter: Alt + C
- Run Spellcheck: F7
- Find Next Match (after initial Find): Ctrl + F4
- Insert Embedded Chart: Alt + F1
- Insert Chart in New Sheet: F11
- Toggle Autofilter: Ctrl + Shift + L
- Activate Filter: Alt + ↓
- Create Table: Ctrl + T
- Select Table Row: Shift + Space
- Select Table Column: Ctrl + Space
- Select Table (when active cell is in table): Ctrl + A
- Clear Slicer Filter: Alt + C
- Run Spellcheck: F7
- Open Thesaurus: Shift + F7
- Back To Index: Ctrl + Home
- Open Macro dialog box: Alt + F8
- Open VBA Editor: Alt + F11
- Duplicate object: Ctrl + D
- Snap to grid (while dragging): Alt
- Hide or show objects: Ctrl + 6
- Open Modify Cell Style dialog box: Alt + ‘
- Show right-click menu: Shift + F10
- Display control menu: Alt + Space
Worksheet Shortcuts
- Insert new worksheet:
Shift + F11
- Go to next worksheet:
Ctrl + PgDn
- Go to previous worksheet:
Ctrl + PgUp
- Rename current worksheet:
Alt + O, H, R
- Delete current worksheet:
Alt + E, L
- Move current worksheet:
Alt + E, M
- Move between the worksheet, Ribbon, task pane, and zoom controls: F6 or Shift + F6
- Toggle scroll lock: ScrLk
- Toggle full screen: Ctrl + Shift + F1
- Navigate between panes: Ctrl + Shift + PgUp/PgDn
- Print: Ctrl + P
- Open print preview window: Ctrl + F2
- Set print area: Alt + P, R S
- Clear print area: Alt + P, R C
- Zoom in: Ctrl + Mouse Wheel Up
- Zoom out: Ctrl + Mouse Wheel Down
- Protect sheet: Alt + R, P S
- Open print preview window: Ctrl + F2
- Set print area: Alt + P, R S
- Clear print area: Alt + P, R C
- Zoom in: Ctrl + Mouse Wheel Up
- Zoom out: Ctrl + Mouse Wheel Down
- Protect sheet: Alt + R, P S
Workbook Shortcuts
- Create new workbook:
Ctrl + N
- Open workbook:
Ctrl + O
- Save workbook:
Ctrl + S
- Save as:
F12
- Go to next workbook:
Ctrl + Tab
- Go to previous workbook:
Ctrl + Shift + Tab
- Minimize current workbook window: Ctrl + F9
- Maximize current workbook window: Ctrl + F10
- Close current workbook: Ctrl + F4
- Close Excel: Alt + F4
- Switch to the previous open workbook: Ctrl + Shift + Tab
Ribbon Shortcuts
- Expand or collapse ribbon: Ctrl + F1
- Activate access keys: Alt
- Move through Ribbon tabs and groups: → (Right Arrow) or ← (Left Arrow)
- Activate or open selected control: Space or Enter
- Confirm control change: Enter
- Get help on selected control: F1
Drag and Drop (After Selecting Cells) Shortcuts
- Drag and cut:
Ctrl + Drag
- Drag and copy:
Shift + Drag
- Drag and insert: Shift + Drag
- Drag and insert copy: Ctrl + Shift + Drag
- Drag to worksheet: Alt + Drag
- Drag to duplicate worksheet: Ctrl + Drag
Navigation Shortcuts
- Move one cell right:
→
- Move one cell left:
←
- Move one cell up:
↑
- Move one cell down:
↓
- Move to right edge of data region:
Ctrl + →
- Move to left edge of data region:
Ctrl + ←
- Move to top edge of data region:
Ctrl + ↑
- Move to bottom edge of data region:
Ctrl + ↓
- Move to the beginning of the row: Home
- Move to the last cell in the worksheet that contains data: Ctrl + End
- Move to the first cell in the worksheet: Ctrl + Home
- Turn End mode on: End
Active Cell Shortcuts
- Select active cell (when multiple cells already selected):
Shift + Backspace
- Show the active cell on the worksheet:
Ctrl + Backspace
- Move active cell clockwise to corners of selection:
Ctrl + .
- Move active cell down in selection – wrap to next column:
Enter
- Move active cell up in selection – wrap to previous column:
Shift + Enter
- Move active cell right in a selection – wrap to next row:
Tab
- Move active cell left in a selection – wrap to previous row:
Shift + Tab
Selection Shortcuts
- Select entire row:
Shift + Space
- Select entire column:
Ctrl + Space
- Select current region if worksheet contains data:
Ctrl + A
- Expand selection:
Shift + Click
- Add non-adjacent cells to selection:
Ctrl + Click
- Move right between non-adjacent selections:
Ctrl + Alt + →
- Move left between non-adjacent selections:
Ctrl + Alt + ←
- Toggle ‘Add to Selection’ mode:
Shift + F8
- Exit ‘Add to Selection’ mode:
Esc
Extend Selection Shortcuts
- Extend selection right:
Shift + →
- Extend selection left:
Shift + ←
- Extend selection up:
Shift + ↑
- Extend selection down:
Shift + ↓
- Extend selection to the last cell on the right that contains data:
Ctrl + Shift + →
- Extend selection to the last cell on the left that contains data:
Ctrl + Shift + ←
- Extend selection to the last cell up that contains data:
Ctrl + Shift + ↑
- Extend selection to the last cell down that contains data:
Ctrl + Shift + ↓
- Extend selection up one screen:
Shift + PgUp
- Extend selection down one screen:
Shift + PgDn
- Right one screen:
Alt + Shift + PgDn
- Left one screen:
Alt + Shift + PgUp
- To start of row(s):
Shift + Home
- To first cell in worksheet:
Ctrl + Shift + Home
- To last cell in worksheet:
Ctrl + Shift + End
- Toggle mode:
F8
- Cancel mode:
Esc
Select Special Shortcuts
- Display ‘Go To’ dialog box:
Ctrl + G OR F5
- Select cells with comments:
Ctrl + Shift + O
- Select current region around active cell:
Ctrl + Shift + *
- Select current region:
Ctrl + A
- Select direct precedents:
Ctrl + [
- Select all precedents:
Ctrl + Shift + {
- Select direct dependents:
Ctrl + ]
- Select all dependents:
Ctrl + Shift + }
- Select visible cells only:
Alt + ;
Cell Edit Mode Shortcuts
- Edit the active cell: F2
- Insert or edit comment: Shift + F2
- Delete comment: Shift + F10 , M
- Cancel editing: Esc
- Select one character right: Shift + →
- Select one character left: Shift + ←
- Move one word right: Ctrl + →
- Move one word left: Ctrl + ←
- Select one word right: Ctrl + Shift + →
- Select one word left: Ctrl + Shift + ←
- Select to beginning of cell: Shift + Home
- Select to end of cell: Shift + En
- Delete to end of line: Ctrl + Delete
- Delete character to left of cursor: Backspace
- Delete character to right of cursor: Delete
- Start a new line in the same cell: Alt + Enter
Entering Data Shortcuts
- Enter data and move down:
Enter
- Enter data and move up:
Shift + Enter
- Enter data and move right:
Tab
- Enter data and move left:
Shift + Tab
- Enter data and stay in the same cell:
Ctrl + Enter
- Enter same data in multiple cells:
Ctrl + ;
- Insert current date:
Ctrl + Shift + :
- Insert current time:
Ctrl + ;
- Fill down from the cell above:
Ctrl + D
- Fill right from the cell on the left:
Ctrl + R
- Copy formula from the cell above (formula is an exact copy):
Ctrl + '
- Copy value from the cell above:
Ctrl + "
- Insert hyperlink:
Ctrl + K
- Display AutoComplete list:
Alt + ↓
- Flash fill:
Ctrl + E
Formatting Shortcuts
- Format cells:
Ctrl + 1
- Display Format Cells with Font tab selected:
Ctrl + Shift + F
- Apply or remove bold:
Ctrl + B
- Apply or remove italics:
Ctrl + I
- Apply or remove underscore:
Ctrl + U
- Apply or remove strikethrough:
Ctrl + 5
- Align center:
Alt + H, A, C
- Align left:
Alt + H, A, L
- Align right:
Alt + H, A, R
- Indent:
Alt + H, 6
- Remove indent:
Alt + H, 5
- Wrap text:
Alt + H, W
- Align top:
Alt + H, A, T
- Align middle:
Alt + H, A, M
- Align bottom:
Alt + H, A, B
- Increase font size one step:
Alt + H, F, G
- Decrease font size one step:
Alt + H, F, K
Number Formatting Shortcuts
- Apply general format: Ctrl + Shift + ~
- Apply number format: Ctrl + Shift + !
- Apply time format: Ctrl + Shift + @
- Apply date format: Ctrl + Shift + #
- Apply currency format: Ctrl + Shift + $
- Apply percentage format: Ctrl + Shift + %
- Apply scientific format: Ctrl + Shift + ^
Borders Shortcuts
- Open list of border styles from Ribbon:
Alt + H, B
- Add border around selected cells:
Ctrl + Shift + &
- Add or remove right border:
Alt + H, B, R
- Add or remove left border:
Alt + H, B, L
- Add or remove top border:
Alt + H, B, P
- Add or remove bottom border:
Alt + H, B, O
- Add all borders to all cells in selection:
Ctrl + Shift + -
- Remove borders:
Ctrl + Shift + _
Formulas Shortcuts
- Begin entering a formula:
= OR + F4
- Toggle absolute and relative references (in cell edit mode):
Shift + F3
- Open the Insert Function Dialog Box:
Alt + =
- Autosum:
Ctrl +
- Toggle displaying formulas on and off:
Ctrl + \
- Insert function arguments:
Ctrl + Shift + A
- Enter array formula: Ctrl + Shift + Enter
- Calculate worksheets: F9
- Calculate active worksheet: Shift + F9
- Force calculate all worksheets: Ctrl + Alt + F9
- Evaluate part of a formula (in cell edit mode): F9
- Expand or collapse the formula bar: Ctrl + Shift + U
- Display function arguments dialog box: Ctrl + A
- Open Name Manager: Ctrl + F3
- Create name from values in row(s)/column(s): Ctrl + Shift + F3
- Paste name into formula: F3
- Accept function with autocomplete: Tab
Rows and Columns Shortcuts
- Display Insert Dialog box:
Ctrl + +
- Insert selected number of rows:
Ctrl + +
- Insert selected number of columns:
Ctrl + +
- Display Delete dialog box:
Ctrl + -
- Delete selected number of rows:
Ctrl + -
- Delete selected number of columns:
Ctrl + -
- Delete contents of selected cells:
Delete
- Hide columns:
Ctrl + 0
- Hide rows:
Ctrl + 9
- Unhide rows:
Ctrl + Shift + 9
- Group rows or columns (with rows/columns selected):
Alt + Shift + →
- Ungroup rows or columns (with rows/columns selected):
Alt + Shift + ←
- Open Group Dialog Box (no rows/cols selected):
Ctrl + 8
- Open Ungroup Dialog Box:
Ctrl + 8
- Hide or show outline symbols:
Ctrl + 8
Pivot Tables Shortcuts
- Create pivot table:
Alt + N, V
- Select the entire pivot table:
Ctrl + A
- Group pivot table items:
Alt + Shift + →
- Ungroup pivot table items:
Alt + Shift + ←
- Hide (filter out) pivot table item:
Ctrl + -
- Unhide (clear filter on) pivot table item:
Alt + H, S, C
- Insert pivot chart: Alt + N , S Z C
Dialog Boxes Shortcuts
- Move to the next control:
Tab
- Move to the previous control:
Shift + Tab
- Move to the next tab:
Ctrl + Tab
- Move to the previous tab:
Shift + Ctrl + Tab
- Accept and apply:
Enter
- Check and uncheck box:
Space
- Cancel and close the dialog box:
Esc
Hope you found the treasure trove of shortcuts I shared super handy! 🚀 From turbocharging your formula game to becoming a wizard at worksheet management, these 220+ Excel keyboard shortcuts are the secret sauce to boosting your efficiency. 🎩✨
Remember, Ctrl + Shift + Enter is your array formula superhero, F9 is the silent calculator, and Ctrl + Alt + F9 is your go-to for a forceful recalculation.
So, whether you’re a spreadsheet newbie or a seasoned pro, these shortcuts are your backstage pass to Excel greatness. Happy shortcutting! 🚀💻🔥