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
© Copyright 2024