Shir Aviv
You’ll see.
Shortcut
646.543.SHIR
[email protected]
http://excelshir.com
Description
1. GENERAL SHORTCUTS
⌘+ N
⌘+ O
⌘+ S
⌘+ P
⌘+ F
CTRL + H
⌘+ W
⌘+ Q
SHIFT + F11
fn + DELETE
Create New File
Open File
Save File
Print File
Find
*Find & Replace
Close Workbook
Quit Application
Insert Blank Worksheet
Clear contents of current cell
3. DATA SELELCTION
SHIFT + ARROWS
⌘+ A
SHIFT + SPACE
CTRL + SPACE
ESC
Expand Selection by One Cell
Select All (within current data region)
Select Entire Row
Select Entire Column
Exit Cell Edit Mode Without Saving Changes
5. DATA MANIPULATION
⌘+ Z
⌘+ Y
⌘+ X
⌘+ C
⌘+ V
CTRL + ⌘ + V
CTRL + + (plus)
CTRL + - (minus)
CTRL + D
CTRL + R
Undo Last Action
Redo Last Action
Cut
Copy
Paste
Paste Special
*Insert Cell/Row/Column (based on selection)
Delete Cell/Row/Column (based on selection)
Auto-Fill Down (copy top cell to current selection)
Auto-Fill Right (copy left cell to current selection)
7. QUICK VALUE SHORTCUTS
⌘+ SHIFT + T
CTRL + ‘ (apostrophe)
CTRL + “ (quotes)
CTRL + ; (semicolon)
CTRL + : (colon)
AutoSum Adjacent Cells
Copy Above Cell Formula Into Active Cell
Copy Above Cell Value Into Active Cell
Insert Today’s Date Value Into Active Cell
Insert Current Time Value Into Active Cell
EXCELSHIR CHEAT SHEET:
KEYBOARD SHORTCUTS
FOR MAC
Shortcut
Description
2. BASIC NAVIGATION
⌘+ ARROWS
⌘+ SHIFT + ARROWS
fn + LEFT (Home)
fn + RIGHT (End)
CTRL + fn + LEFT (Home)
CTRL + fn + RIGHT (End)
CTRL + fn + DOWN (PgDn)
CTRL + fn + UP (PgUp)
⌘+ ` (grave)
⌘+ SHIFT + ` (grave)
Move to the Next Nonblank Cell
Select from Active Cell to Next Nonblank Cell
Start of Row
Turn on “End Mode” (same as ⌘ + ARROWS)
First Cell of Worksheet
Last Cell of Worksheet
Next Worksheet
Previous Worksheet
Next Workbook
Previous Workbook
4. BASIC FORMATTING
⌘+ 1
⌘+ B
⌘+ I
⌘+ U
CTRL + U
Format Cells
Bold
Italics
Underline
Edit Cell Contents
6. ADVANCED FORMATTING
CTRL + SHIFT + ~
CTRL + SHIFT + 1
CTRL + SHIFT + 2
CTRL + SHIFT + 3
CTRL + SHIFT + 4
CTRL + SHIFT + 5
CTRL + OPT + RETURN
⌘+ OPT + - (minus)
⌘+ OPT + 0 (zero)
⌘+ OPT + ARROWS
Format Cells as “General”
Format Cells as “Number” (with 2 decimals)
Format Cells as “Date”
Format Cells as “Time”
Format Cells as “Currency”
Format Cells as “Percent”
Insert Line Break (in cell edit mode)
Remove All Borders to Current Selection
Add Outside Borders to Current Selection
Apply Single Border to Current Selection
8. RANDOM SHORTCUTS
⌘+ Y
⌘+ T (in cell edit mode)
CTRL + ` (grave)
fn + OPT + F11
fn + OPT + F8
Repeat Last Action
Toggle Absolute/Relative Cell References
Toggle Formula Audit Mode
Open Visual Basic Editor (VBE)
Open Macro List
*Keyboard Shortcut Customization Instructions: Tools → Customize Keyboard
Copyright © ExcelShir, All Rights Reserved
XLS003a1
2K1409251722
Additional Resources:
http://excelshir.com/resources