Excel Keyboard Shortcuts | Excel Learning Hub

Data

Ctrl T

Convert the selected range into a Table Windows

Cmd T

Convert the selected range into a Table Mac

Ctrl Shift ;

Insert the current time as a static value Windows

Ctrl ;

Insert today's date as a static value Windows

Cmd ;

Insert today's date as a static value Mac

Ctrl Shift Space

Select the current region (or the whole sheet if pressed twice) Windows

Ctrl Space

Select the entire column Windows

Shift Space

Select the entire row Windows

Ctrl Shift L

Toggle filters on the selected header row Windows

Cmd Shift F

Toggle filters on the selected header row Mac

Editing

Delete

Clear the contents of selected cells

Ctrl C

Copy Windows

Cmd C

Copy Mac

Ctrl '

Copy the formula from the cell above Windows

Ctrl X

Cut Windows

Cmd X

Cut Mac

F2

Edit the selected cell

Ctrl D

Fill down (copy the cell above) Windows

Cmd D

Fill down (copy the cell above) Mac

Ctrl V

Paste Windows

Cmd V

Paste Mac

Ctrl Y

Redo Windows

Cmd Y

Redo Mac

Ctrl Z

Undo Windows

Cmd Z

Undo Mac

File & View

Shift F11

Insert a new worksheet Windows

Ctrl N

New workbook Windows

Cmd N

New workbook Mac

Ctrl P

Print Windows

Cmd P

Print Mac

Ctrl S

Save Windows

Cmd S

Save Mac

F12

Save As Windows

Formatting

Ctrl Shift $

Apply Currency format Windows

Ctrl Shift %

Apply Percentage format Windows

Ctrl B

Bold Windows

Cmd B

Bold Mac

Ctrl 0

Hide selected columns Windows

Ctrl 9

Hide selected rows Windows

Ctrl I

Italic Windows

Cmd I

Italic Mac

Ctrl 1

Open Format Cells dialog Windows

Cmd 1

Open Format Cells dialog Mac

Ctrl U

Underline Windows

Cmd U

Underline Mac

Ctrl Shift 0

Unhide columns Windows

Ctrl Shift 9

Unhide rows Windows

Formulas

Alt =

AutoSum Windows

Shift Cmd T

AutoSum Mac

Ctrl Shift Enter

Enter a legacy array formula Windows

F9

Recalculate all open workbooks Windows

F4

Repeat last action, or toggle absolute/relative cell references while editing a formula Windows

Ctrl `

Toggle showing formulas instead of their results Windows

Cmd `

Toggle showing formulas instead of their results Mac

Navigation

Ctrl Home

Jump to cell A1

Ctrl Arrow Key

Jump to the edge of the current data region

Ctrl End

Jump to the last used cell on the sheet

Enter

Move one cell down (or confirm entry and move down)

Tab

Move one cell right (or confirm entry and move right)

Ctrl F

Open Find

F5

Open Go To

Page Up / Page Down

Scroll up or down one screen

Ctrl Page Down

Switch to the next worksheet

Ctrl Page Up

Switch to the previous worksheet