Microsoft Excel Keyboard Shortcuts for Windows & macOS

Windows & macOS

Microsoft Excel is essential for data analysis and spreadsheets. These keyboard shortcuts help you enter, edit, and manage data efficiently across both platforms.

Frequently Used Shortcuts

Action	Windows	macOS
New workbook	Ctrl N	⌘ N
Open workbook	Ctrl O	⌘ O
Save workbook	Ctrl S	⌘ S
Print	Ctrl P	⌘ P
Undo	Ctrl Z	⌘ Z
Redo	Ctrl Y	⌘ Y
Copy	Ctrl C	⌘ C
Cut	Ctrl X	⌘ X
Paste	Ctrl V	⌘ V
Find	Ctrl F	⌘ F
Replace	Ctrl H	Ctrl H
Select all	Ctrl A	⌘ A
Bold	Ctrl B	⌘ B
Italic	Ctrl I	⌘ I
Underline	Ctrl U	⌘ U
Insert hyperlink	Ctrl K	⌘ K

Work in Windows & Dialog Boxes

Action	Windows	macOS
Close window	Ctrl W	⌘ W
Move to next open workbook	Ctrl Tab	⌘ Tab
Move to previous workbook	Ctrl Shift Tab	⌘ Shift Tab
Open help	F1	Fn ⌘ ?
Expand/collapse ribbon	Ctrl F1	⌘ Option R
Open context menu	Shift F10	Shift F10

Move & Scroll in a Sheet or Workbook

Action	Windows	macOS
Move one cell up, down, left, right	Arrow keys	Arrow keys
Jump to beginning of row	Home	Fn ←
Jump to first cell (A1)	Ctrl Home	Fn ⌘ ←
Jump to last cell with data	Ctrl End	Fn ⌘ →
Move one screen down	Page Down	Fn ↓
Move one screen up	Page Up	Fn ↑
Move one screen right	Alt Page Down	Option Page Down
Move one screen left	Alt Page Up	Option Page Up

Enter Data on a Sheet

Action	Windows	macOS
Start a new line in cell	Alt Enter	Control Option Return
Fill selected cell with contents above	Ctrl D	⌘ D
Fill right	Ctrl R	⌘ R
Complete cell entry	Enter	Return
Cancel cell entry	Esc	Esc

Work in Cells or Formula Bar

Action	Windows	macOS
Edit selected cell	F2	Control U
Insert function	Shift F3	Fn Shift F3
Toggle absolute/relative references	F4	⌘ T
Expand formula bar	Ctrl Shift U	⌘ Shift U
Calculate active worksheet	Shift F9	Fn Shift F9
Calculate all worksheets	F9	Fn F9

Format & Edit Data

Action	Windows	macOS
Open Format Cells dialog	Ctrl 1	⌘ 1
Apply General format	Ctrl Shift ~	⌘ Shift ~
Apply Currency format	Ctrl Shift $	⌘ Shift $
Apply Percentage format	Ctrl Shift %	⌘ Shift %
Apply Date format	Ctrl Shift #	⌘ Shift #
Apply Time format	Ctrl Shift @	⌘ Shift @
Apply Number format	Ctrl Shift !	⌘ Shift !
Insert current date	Ctrl ;	⌘ ;
Insert current time	Ctrl Shift ;	⌘ Shift ;

Select Cells, Columns, or Rows

Action	Windows	macOS
Select entire row	Shift Space	Shift Space
Select entire column	Ctrl Space	Control Space
Select all cells	Ctrl A	⌘ A
Extend selection one cell	Shift Arrow	Shift Arrow
Extend selection to last used cell	Ctrl Shift End	Fn ⌘ Shift →
Extend selection to first cell	Ctrl Shift Home	Fn ⌘ Shift ←

Work with a Selection

Action	Windows	macOS
Copy selection	Ctrl C	⌘ C
Cut selection	Ctrl X	⌘ X
Paste selection	Ctrl V	⌘ V
Delete selection	Delete	Delete
Repeat last action	F4	⌘ Y

Use Charts

Action	Windows	macOS
Create chart	Alt F1	Fn Option F1
Create chart in new sheet	F11	Fn F11

Sort, Filter & Use PivotTables

Action	Windows	macOS
Open Sort dialog	Alt D S	Option Shift Command R
Apply filter	Ctrl Shift L	⌘ Shift F
Group data	Alt Shift →	Option Shift →
Ungroup data	Alt Shift ←	Option Shift ←
Insert PivotTable	Alt N V	Option ⌘ P

Outline Data

Action	Windows	macOS
Show outline symbols	Ctrl 8	⌘ 8
Hide detail	Alt Shift –	Option Shift –
Show detail	Alt Shift +	Option Shift +

Function Key Shortcuts

Action	Windows	macOS
Help	F1	Fn ⌘ ?
Rename active cell	F2	Control U
Repeat last action	F4	⌘ Y
Go to dialog	F5	Fn F5
Recalculate all worksheets	F9	Fn F9
Insert new chart	F11	Fn F11

Drawing

Action	Windows	macOS
Insert shape	Alt N S H	Option ⌘ Shift H
Insert text box	Alt N X	Option ⌘ Shift X
Select drawing objects	Ctrl Click	⌘ Click
Move drawing object	Arrow keys	Arrow keys

Official reference:

macOS

Windows