Excel En Mac

ADVANCED EXCEL KEYBOARD SHORTCUTS – MACINTOSH
EXCEL KEYSTROKES ACTION
EXCEL KEYSTROKES
ACTION
DATA SELECTION / NAVIGATION
FORMATTING
Ctrl + Pg Up / Pg Down Move to Prior / Next Worksheet
z +Shift + V
Paste Special (copy first)
Shift / Ctrl + Spacebar
Select Entire Row / Column
z+B/U/I
Toggle Bold / Underline / Italic
Ctrl + * (Ctrl + Shift + 8) Select All Adjacent Cells
z+1
FormatCells
z+A
Select Entire Worksheet
z + Option + 0
Box Selection
Shift + F8
Add to Selection
z + Option + Hyphen
No Border
z + Shift + K / J
Ctrl + 0 / 9
Ctrl + Shift + 0 / 9

Group /Ungroup Selection
Collapse (Hide Columns / Rows)
Expand (Unhide Columns / Rows)

Ctrl + Arrow Keys
Shift + Arrow Keys
Ctrl + Home / End
Ctrl + . (within selection)

Move by Blocks of CellsSelect Cells
Move to Upper Left / Lower Right
Move Clockwise to next Corner

Ctrl + – / Ctrl + +
Option + ↓

Delete / Insert Selected Cells
Show Dropdown List Options

Option + F10
Ctrl + TabTab + Shift

Option + Ctrl + (Shift) + Tab Increase / Decrease Indent
z + Shift + . / ,
Increase / Decrease Font Size
EDITING
Ctrl + U
z + T (edit mode)
Ctrl + Enter

Toggle Edit / NavigationMode
Toggle Anchoring ($ in cell ref)
Fill Selection with Formula / Text

Shift + F2
Shift + F3
z + = / Shift + F9
Ctrl + Option + Enter

Insert Comment (Esc twice to exit)
Display FormulaDialog Box
Calc Entire File / Active Sheet Only
Start New Line in Cell

Activate Toolbars
Scroll thru Toolbars
Scroll thru Icons / Functions

Ctrl + ; / :
Ctrl + ` (tilda)

Insert Date /Time as Value
Toggle Cell Values / Formulas

DATA MANIPULATION
z+C/V/X
Ctrl + R / D
z+Z/Y
z + F or Shift + F5

Copy / Paste / Cut
Autofill (Copy Paste Right / Down)
Undo / Redo Last ActionFind

INPUTS VS. FORMULAS
Change all Inputs to Blue :
– Go To ("F5", Ctrl + G, Edit => Go To)
– Select "Special" then "Constants", "OK" (selects all inputs)
– Manually change selection to blue...