Excel Keyboard Shortcuts

Complete list of essential Excel shortcuts to boost your productivity

F1

Help

Displays the Office Assistant or (Help > Microsoft Excel Help)

F2

Edit Cell

Edits the active cell, putting the cursor at the end

F4

Repeat Action

Repeats the last worksheet action (Edit > Repeat)

Ctrl + 1

Format Cells

Displays the formatting dialog box

Ctrl + B

Bold

Toggles bold on the current selection

Ctrl + I

Italic

Toggles italics on the current selection

Ctrl + Home

Go to A1

Moves to cell "A1" on the active sheet

Ctrl + End

Last Cell

Moves to the last used cell on the active worksheet

Ctrl + Arrow Keys

Jump to Edge

Moves to the edge of data region in arrow direction

Ctrl + A

Select All

Selects the entire worksheet or current region

Shift + Space

Select Row

Selects the entire current row

Ctrl + Space

Select Column

Selects the entire current column

Ctrl + ;

Current Date

Enters the current date into the active cell

Alt + =

AutoSum

Enters the SUM() function to sum adjacent cells

Ctrl + Enter

Fill Selection

Fills the selected cells with current entry

Most Used Shortcuts

Ctrl + C

Copy

Ctrl + V

Paste

Ctrl + Z

Undo

Ctrl + S

Save