Most Useful Excel Keyboard Shortcuts
Description Windows Mac OS
Copy Ctrl + C Command + C or Ctrl + C
Paste Ctrl + V Command + V or Ctrl + V
Cut Ctrl + S Command + X or Ctrl + X
Undo Ctrl + Z Command + Z or Ctrl + Z
Redo Ctrl + Y Command + Y or Ctrl + Y or Command +
Shift + Z
Remove Cell Contents Delete Delete
Bold Ctrl + B Command + B or Ctrl + B
Italic Ctrl + I Command + I or Ctrl + I
Underline Ctrl + U Command + U or Ctrl + U
Fill cells down Ctrl + D Command + D or Ctrl + D
Fill cells right Ctrl + R Command + R or Ctrl + R
ATUL KUMAR (LINKEDIN) 1
Insert cells Ctrl + Shift + Ctrl + Shift + Equal sign (=)
Plus sign (+)
Delete cells Ctrl + Hyphen Command + Hyphen (-) or Ctrl + Hyphen (-
(-) )
Save Ctrl + S Command + S or Ctrl + S
Save As F12 Command + Shift + S or F12
Print Ctrl + P Command + P or Ctrl + P
Close Window Ctrl + W or Ctrl Command + W or Ctrl + W
+ F4
Quit Excel Alt + F4 Command + Q
ATUL KUMAR (LINKEDIN) 2
Move and Scroll using Keyboard
Shortcuts
Description Windows Mac OS
Navigation between Arrow keys Arrow keys
cells
Navigation between Tab key Tab key
unlocked cells on a
protected sheet
Horizontal Scrolling Shift + Shift + scroll the mouse wheel up for left and
scroll the down for right
mouse
wheel up for
left and
down for
right
Access Go To Alt + G Ctrl + G
Access Find Alt + F Ctrl + F or Shift + F5
Access search while in Ctrl + F Command + F
a cell
Move to the edge of Ctrl + Arrow Command + Arrow key
the selected data key
region
ATUL KUMAR (LINKEDIN) 3
Move to the start of a Alt + H Home or Fn + Left arrow key
row
Move to the start of Ctrl + Home Ctrl + Home or Ctrl + Fn + Left arrow key
the sheet
Move to last used cell Ctrl + End Ctrl + End or Ctrl + Fn + Right arrow key
on the sheet
Navigate one screen Page down Page down or Fn + Down arrow key
down
Navigate one screen up Page up Page up or Fn + Up arrow key
Navigate one screen to Alt + Page Alt + Page down or Fn + Alt + Down arrow
the right down key
Navigate one screen to Alt + Page Alt + Page up or Fn + Alt + Up arrow key
the left up
Navigate the next Ctrl + Page Ctrl + Page up or Alt + Right arrow key
sheet down
Navigate the previous Ctrl + Page Ctrl + Page down or Alt + Left arrow key
sheet up
Scroll to active cell Shift + Tab Ctrl + Delete
CREATED BY LearnPro)
LearnPro.in 4
