Shortcuts

Excel Shortcuts: Your Superpower in Spreadsheets!

What are Shortcuts in Excel?

Imagine having a magic wand for Excel – wave it, and poof! Your tasks are done. That’s essentially what shortcuts are! They’re special key combinations that tell Excel, “Hey, do this cool thing for me, pronto!” Instead of clicking through menus like you’re navigating a labyrinth, shortcuts let you cast spells (okay, commands) with just a few keystrokes. It’s like being a wizard, but for spreadsheets!

Why Use Excel Shortcuts?

  1. Speed Demon: Shortcuts make you faster than a formula calculating at the speed of light!
  2. Efficiency Expert: Less time on mundane tasks = More time for spreadsheet sorcery.
  3. Ergonomic Elegance: Give your poor mouse a break. Your keyboard is lonely!
  4. Impress Your Peers: Watch jaws drop as you manipulate Excel without touching your mouse.
  5. Boost Productivity: Get more done in less time. It’s like having a Time-Turner for your workday!

Types of Shortcuts in Excel

Excel shortcuts come in flavors more varied than a bag of jelly beans. Here’s a taste:

  1. File Operations: Open, save, print – faster than you can say “TPS Report.”
  2. Editing Enchantments: Cut, copy, paste – the holy trinity of data manipulation.
  3. Formatting Frenzy: Make your cells pretty in a jiffy.
  4. Navigation Ninja Moves: Zip through your spreadsheet like you’re on a hoverboard.
  5. Formula Wizardry: Summon functions and vanquish calculation errors.
  6. Data Sorcery: Sort, filter, and pivot your data into submission.
  7. Visual Tricks: Charts, conditional formatting – make your data pop!
  8. Power User Potions: Macros, VBA – for when you’re ready to enter the Excel matrix.

Using Shortcuts: The Art of Excel Spellcasting

Casting an Excel spell (er, using a shortcut) is easier than pronouncing “Expelliarmus”:

  1. Most shortcuts involve holding down one or more keys (Ctrl, Alt, Shift) and then pressing another key.
  2. For example, to bold text: Hold Ctrl, then press B. Ctrl+B. Boom! Bold.
  3. Some shortcuts are single magic words (function keys like F2 to edit a cell).
  4. Mac users, substitute Command for Ctrl in most cases, and you’re golden.
  5. Practice makes perfect. Soon, your fingers will be flying across the keyboard, performing Excel miracles without you even thinking about it!

Remember, young padawan, mastering Excel shortcuts is a journey. You might fumble at first, but soon you’ll be shortcutting circles around your spreadsheets. Now, go forth and multiply (your productivity)!

115 Excel Shortcuts for PC and Mac

File Operations

Shortcut NamePC KeysMac Keys
Open a workbookCtrl + OCommand + O
Create a new workbookCtrl + NCommand + N
Save a workbookCtrl + SCommand + S
Close a workbookCtrl + WCommand + W
PrintCtrl + PCommand + P

Editing

Shortcut NamePC KeysMac Keys
UndoCtrl + ZCommand + Z
RedoCtrl + YCommand + Y
CutCtrl + XCommand + X
CopyCtrl + CCommand + C
PasteCtrl + VCommand + V
FindCtrl + FCommand + F
ReplaceCtrl + HCommand + H
Go toCtrl + GControl + G
Select allCtrl + ACommand + A

Formatting

Shortcut NamePC KeysMac Keys
BoldCtrl + BCommand + B
ItalicCtrl + ICommand + I
UnderlineCtrl + UCommand + U
Align leftCtrl + LCommand + L
Align centerCtrl + ECommand + E
Align rightCtrl + RCommand + R
Format cellsCtrl + 1Command + 1

Data Entry and Manipulation

Shortcut NamePC KeysMac Keys
Insert hyperlinkCtrl + KCommand + K
Fill downCtrl + DCommand + D
Fill rightCtrl + RCommand + R
Insert current dateCtrl + ;Control + ;
Insert current timeCtrl + Shift + :Command + ;
Delete selected cellsCtrl + –Control + –
Insert selected cellsCtrl + +Control + Shift + +
Define nameCtrl + F3Command + F3
Create absolute cell referenceF4Fn + F4
Edit active cellF2Control + U
AutosumAlt + =Command + Shift + T
Fill handle dragCtrl + DragCommand + Drag
Copy formula from cell aboveCtrl + ‘Control + ‘
Insert commentShift + F2Shift + Fn + F2

Worksheet Management

Shortcut NamePC KeysMac Keys
Insert new worksheetShift + F11Shift + Fn + F11
Hide selected rowsCtrl + 9Command + 9
Unhide selected rowsCtrl + Shift + 9Command + Shift + 9
Hide selected columnsCtrl + 0Command + 0
Unhide selected columnsCtrl + Shift + 0Command + Shift + 0
Group rows or columnsAlt + Shift + Right ArrowOption + Shift + Right Arrow
Ungroup rows or columnsAlt + Shift + Left ArrowOption + Shift + Left Arrow
Go to previous worksheetCtrl + Page UpFn + Control + Up Arrow
Go to next worksheetCtrl + Page DownFn + Control + Down Arrow

Navigation and Selection

Shortcut NamePC KeysMac Keys
Select current regionCtrl + Shift + *Control + Shift + Space
Move to edge of data regionCtrl + Arrow KeyCommand + Arrow Key
Select to edge of data regionCtrl + Shift + Arrow KeyCommand + Shift + Arrow Key

Miscellaneous

Shortcut NamePC KeysMac Keys
Create chartAlt + F1Option + F1
Insert functionShift + F3Shift + Fn + F3
Expand or collapse ribbonCtrl + F1Command + Option + R

Formula and Function Management

Shortcut NamePC KeysMac Keys
Insert function wizardAlt + =Shift + F3
Create array formulaCtrl + Shift + EnterControl + Shift + Enter
Calculate all worksheetsF9Fn + F9
Calculate active worksheetShift + F9Shift + Fn + F9
Toggle absolute/relative referencesF4Command + T
Show formulas in cellsCtrl + | Control +
Expand/collapse formula barCtrl + Shift + UControl + Shift + U
Select cells with commentsCtrl + Shift + OControl + Shift + O

Data Analysis and PivotTables

Shortcut NamePC KeysMac Keys
Insert PivotTableAlt + N + VOption + Control + P
Refresh PivotTableAlt + F5Option + Command + F5
Group PivotTable itemsAlt + Shift + Right ArrowOption + Shift + Right Arrow
Ungroup PivotTable itemsAlt + Shift + Left ArrowOption + Shift + Left Arrow
Create PivotChartAlt + F1Fn + Option + F1
Insert slicerAlt + N + J + SNo direct equivalent
Insert timelineAlt + N + J + TNo direct equivalent
Show field list in PivotTableAlt + JTControl + Shift + F10

Cell and Range Formatting

Shortcut NamePC KeysMac Keys
Open format cells dialogCtrl + 1Command + 1
Apply general formatCtrl + Shift + ~Control + Shift + ~
Apply currency formatCtrl + Shift + $Control + Shift + $
Apply percentage formatCtrl + Shift + %Control + Shift + %
Apply scientific formatCtrl + Shift + ^Control + Shift + ^
Apply date formatCtrl + Shift + #Control + Shift + #
Apply time formatCtrl + Shift + @Control + Shift + @
Apply number formatCtrl + Shift + !Control + Shift + !
Apply outline borderCtrl + Shift + &Command + Option + 0
Remove outline borderCtrl + Shift + _Command + Option + –

Text Formatting

Shortcut NamePC KeysMac Keys
Increase font sizeCtrl + Shift + >Command + Shift + >
Decrease font sizeCtrl + Shift + <Command + Shift + <
Toggle strikethroughCtrl + 5Command + Shift + X
Toggle subscriptCtrl + =Command + =
Toggle superscriptCtrl + Shift + +Command + Shift + +
Apply cell stylesAlt + ‘Control + Shift + S

Data Validation and Protection

Shortcut NamePC KeysMac Keys
Apply data validationAlt + D + LNo direct equivalent
Protect/unprotect worksheetAlt + R + P + PNo direct equivalent
Protect workbookAlt + R + P + WNo direct equivalent
Allow users to edit rangesAlt + R + P + RNo direct equivalent

View and Window Management

Shortcut NamePC KeysMac Keys
Toggle full screenAlt + V + UCommand + Control + F
Zoom inCtrl + Alt + +Command + Option + +
Zoom outCtrl + Alt + –Command + Option + –
Reset zoom to 100%Ctrl + Alt + 0Command + Option + 0
Switch between open workbooksCtrl + TabCommand + ~
Arrange all windowsAlt + W + ANo direct equivalent
Freeze/unfreeze panesAlt + W + FCommand + Option + F
Split/remove splitAlt + W + SCommand + Option + S
Hide/unhide rowsCtrl + 9Command + 9
Hide/unhide columnsCtrl + 0Command + 0

Reviewing and Collaboration

Shortcut NamePC KeysMac Keys
Insert commentShift + F2Shift + Fn + F2
Show/hide commentsCtrl + Shift + F12Command + Option + F12
Go to next commentCtrl + Page DownFn + Control + Down Arrow
Go to previous commentCtrl + Page UpFn + Control + Up Arrow
Track changesCtrl + Shift + ENo direct equivalent
Accept changesAlt + R + ANo direct equivalent
Reject changesAlt + R + JNo direct equivalent

Macro and VBA

Shortcut NamePC KeysMac Keys
Open Visual Basic EditorAlt + F11Option + F11
Run a macroAlt + F8Option + F8
Record a macroAlt + T + M + ROption + Command + R
Stop recording a macroAlt + T + M + ROption + Command + R

Advanced Features

Shortcut NamePC KeysMac Keys
Create a tableCtrl + TCommand + T
Insert sparklinesAlt + N + KNo direct equivalent
Create a named rangeCtrl + F3Command + F3
Use the Goal Seek featureAlt + A + W + GNo direct equivalent
Open the Solver add-inAlt + A + W + VNo direct equivalent
Insert a screenshotAlt + N + SNo direct equivalent
Insert SmartArtAlt + N + MNo direct equivalent