GENERAL SHORTCUTS

Master the essentials with these general Excel shortcuts that

boost your efficiency, helping you navigate, manage, and modify
your spreadsheets with ease.

F1 Open help

Ctrl + Z Undo last action

Ctrl + Y Redo last action

Ctrl + C Copy selection

F4 Repeat last action

Ctrl + X Cut selection

Ctrl + V Paste content from clipboard

Ctrl + Alt + V Display the Paste Special dialog box

Ctrl + F Display find and replace with Find tab selected

Ctrl + H Display find & replace with Replace tab selected

Ctrl + Shift + F4 Find previous match (after initial Find)

 GENERAL SHORTCUTS
Master the essentials with these general Excel shortcuts that
boost your efficiency, helping you navigate, manage, and modify
your spreadsheets with ease.

Shift + F4 Find next match (after initial Find)

Alt + F1 Insert embedded chart

F11 Insert chart in new sheet

Ctrl + Shift + L Toggle Autofilter

Alt + ↓ Activate filter

Ctrl + T Create table

Shift + Space Select table row

Ctrl + Space Select table column

Ctrl + A Select table (when active cell is in table)

Alt + C Clear slicer filter

F7 Run Spellcheck
 GENERAL SHORTCUTS
Master the essentials with these general Excel shortcuts that
boost your efficiency, helping you navigate, manage, and modify
your spreadsheets with ease.

Shift + F7 Open Thesaurus

Alt + F8 Open Macro dialog box

Alt + F11 Open VBA Editor

Ctrl + D Duplicate object, formula, text

Alt Snap to grid (whilst dragging)

Ctrl + 6 Hide or show objects

Alt + ' Open Modify Cell Style dialog box

Shift + F10 Show right-click menu

Alt Space Display control menu

 WORKSHEET SHORTCUTS
Streamline your workflow across different sheets with these
shortcuts, enabling quick navigation, management, and
organization of multiple worksheets in Excel.

Shift + F11 Insert new worksheet

Ctrl + PgDn Go to next worksheet

Ctrl + PgUp Go to previous worksheet

Alt + O, H R Rename current worksheet

Alt + E, L Delete current worksheet

Alt + E, M Move current worksheet

F6 Select adjacent worksheets

Ctrl + Click Select non-adjacent worksheets

ScrLk Toggle scroll lock

Ctrl + Shift + F1 Toggle full screen

Ctrl + P Print
WORKSHEET SHORTCUTS
Streamline your workflow across different sheets with these
shortcuts, enabling quick navigation, management, and
organization of multiple worksheets in Excel.

Ctrl + F2 Open print preview window

Alt + P, R S Set print area

Alt + P, R C Clear print area

Ctrl + Mouse Wheel Up Zoom in

Ctrl + Mouse Wheel Down Zoom out

Alt + R, P S Protect sheet

FORMATTING SHORTCUTS
Quickly enhance the visual appeal and readability of your data with
formatting shortcuts, covering everything from bold text to
applying cell borders.

Ctrl + 1 Format cells

Ctrl + Shift + F Display Format Cells with Font tab selected

Ctrl + B Apply or remove bold

Ctrl + I Apply or remove italics

Ctrl + U Apply or remove underscore

Ctrl + 5 Apply or remove strikethrough

Alt + H, A C Align center

Alt + H, A L Align left

Alt + H, A R Align right

Alt + H, 6 Indent

Alt + H, 5 Remove indent

FORMATTING SHORTCUTS
Quickly enhance the visual appeal and readability of your data with
formatting shortcuts, covering everything from bold text to
applying cell borders.

Alt + H, W Wrap text

Alt + H, A T Align top

Alt + H, A M Align middle

Alt + H, A B Align bottom

Alt + H, F G Increase font size one step

Alt + H, F K Decrease font size one step

ENTERING DATA SHORTCUTS
Speed up your data entry process with these shortcuts, designed
to make inputting numbers, text, and formulas faster and more
accurate.

Enter Enter data and move down

Shift + Enter Enter data and move up

Tab Enter data and move right

Shift + Tab Enter data and move left

Ctrl + Enter Enter data and stay in same cell

Enter Enter same data in multiple cells (after copying)

Ctrl + ; Insert current date

Ctrl + Shift + : Insert current time

Ctrl + D Fill down from cell above

Ctrl + R Fill right from cell on left

Ctrl + ' Copy formula from cell above (formula is exact copy)
ENTERING DATA SHORTCUTS
Speed up your data entry process with these shortcuts, designed
to make inputting numbers, text, and formulas faster and more
accurate.

Ctrl + Shift + " Copy value from cell above

Ctrl + K Insert hyperlink

Alt + ↓ Display AutoComplete list

Ctrl + E Flash fill

 RIBBON SHORTCUTS
Navigate Excel’s Ribbon like a pro with these shortcuts, giving you
quick access to commands and tools without needing to leave
your keyboard.

Ctrl + 1 Expand or collapse ribbon

Alt Activate access keys

→←↑↓ Move through Ribbon tabs and groups

Space OR Enter Activate or open selected control

Enter Confirm control change

F1 Get help on selected control

CELL EDIT MODE SHORTCUTS
Edit cells efficiently with shortcuts that help you quickly modify,
correct, and finalize your data entries... without disrupting your
flow.

F2 Edit the active cell

Shift + F2 Insert or edit comment

Shift + F10, M Delete comment

Esc Cancel editing

Shift + → Select one character right

Shift + ← Select one character left

Ctrl + → Move one word right

Ctrl + ← Move one word left

Ctrl + Shift + → Select one word right

Ctrl + Shift + ← Select one word left

Shift + Home Select to beginning of cell

CELL EDIT MODE SHORTCUTS
Edit cells efficiently with shortcuts that help you quickly modify,
correct, and finalize your data entries... without disrupting your
flow.

Shift + End Edit the active cell

Ctrl + Delete Insert or edit comment

Backspace Delete comment

Delete Cancel editing

SELECT SPECIAL SHORTCUTS
Easily select specific types of data or ranges with these shortcuts,
allowing you to manipulate only the cells that matter in your
analysis.

Ctrl + G OR F5 Display 'Go To' dialog box

Ctrl + Shift + O Select cells with comments

Ctrl + Shift + * Select current region around active cell

Ctrl + A Select current region

Ctrl + [ Select direct precedents

Ctrl + Shift + { Select all precedents

Ctrl + ] Select direct dependents

Ctrl + Shift + } Select all dependents

Alt + ; Select visible cells only

EXT. SELECTION SHORTCUTS
Expand your selections in Excel with ease using these shortcuts,
perfect for highlighting large data ranges or multiple areas in your
worksheet.

Shift + → Extend selection right

Shift + ← Extend selection left

Shift + ↑ Extend selection up

Shift + ↓ Extend selection down

Ctrl + Shift + → Extend the selection to the last cell on the right

Ctrl + Shift + ← Extend the selection to the last cell on the left

Ctrl + Shift + ↑ Extend the selection to the last cell up

Ctrl + Shift + ↓ Extend the selection to the last cell down

Shift + PgUp Extend selection up one screen

Shift + PgDn Extend selection down one screen

Alt + Shift + PgDn Extend selection right one screen

EXT. SELECTION SHORTCUTS
Expand your selections in Excel with ease using these shortcuts,
perfect for highlighting large data ranges or multiple areas in your
worksheet.

Alt + Shift + PgUp Extend selection left one screen

Shift + Home Extend selection to start of row(s)

Ctrl + Shift + Home Extend selection to first cell in worksheet

Ctrl + Shift + End Extend selection to last cell in worksheet

F8 Toggle 'Extend Selection' mode

Esc Cancel 'Extend Selection' mode

NAVIGATION SHORTCUTS
Move swiftly through your Excel workbook with navigation
shortcuts that take you to any cell, row, or column without the
hassle.

→ Move one cell right

← Move one cell left

↑ Move one cell up

↓ Move one cell down

Alt + PgDn Move one screen right

Alt + PgUp Move one screen left

PgUp Move one screen up

PgDn Move one screen down

Ctrl + → Move to right edge of data region

Ctrl + ← Move to left edge of data region

Ctrl + ↑ Move to top edge of data region

NAVIGATION SHORTCUTS
Move swiftly through your Excel workbook with navigation
shortcuts that take you to any cell, row, or column without the
hassle.

Ctrl + ↓ Move to bottom edge of data region

Home Move to beginning of row

Ctrl + End Move to last cell in worksheet that contains data

Ctrl + Home Move to first cell in worksheet

End Turn End mode on

 SELECTION SHORTCUTS
Master the art of selecting cells, ranges, and objects in Excel with
these shortcuts, optimizing your workflow for quick and accurate
modifications.

Shift + Space Select entire row

Ctrl + Space Select entire column

Ctrl + A Select current region if worksheet contains data.

Shift + Click Expand selection

Ctrl + Click Add non-adjacent cells to selection

Ctrl + Alt + → Move right between non-adjacent selections

Ctrl + Alt + ← Move left between non-adjacent selections

Shift + F8 Toggle 'Add to Selection' mode

Esc Exit 'Add to Selection' mode

DRAG & DROP SHORTCUTS
Simplify your data management tasks with drag and drop
shortcuts, enabling you to quickly move, copy, or adjust your data
within the worksheet.

Drag Display 'Go To' dialog box

Ctrl + Drag Select cells with comments

Shift + Drag Select current region around active cell

Ctrl + Shift + Drag Select current region

Alt + Drag Select direct precedents

Ctrl + Drag Select all precedents

 ACTIVE CELL SHORTCUTS
Stay in control of your data by mastering active cell shortcuts,
ensuring that you can efficiently manage the current cell’s content
and behavior.

Shift + Backspace Select active cell (+1 cells already selected)

Ctrl + Backspace Show the active cell on worksheet

Ctrl + . Move active cell clockwise to corners of selection

Enter Move active cell down in selection

Shift + Enter Move active cell up in selection

Tab Select all precedents

Shift + Tab Move active cell left in a selection