Excel Shortcuts - ExcelBaby

General	Windows	Mac
Open Excel help	`F1`	`⌘` `/`
Undo last action	`Ctrl` `Z`	`⌘` `Z`
Redo last action	`Ctrl` `Y`	`⌘` `Y`
Copy selected cells	`Ctrl` `C`	`⌘` `C`
Cut selected cells	`Ctrl` `X`	`⌘` `X`
Paste content from clipboard	`Ctrl` `V`	`⌘` `V`
Display the Paste Special dialog box	`Ctrl` `Alt` `V`	`Control` `⌘` `V`
Display find and replace	`Ctrl` `F`	`⌘` `F`
Display find and replace, replace selected	`Ctrl` `H`	`Control` `H`
Find next match	`Shift` `F4`	`⌘` `G`
Find previous match	`Ctrl` `Shift` `F4`	`⌘` `Shift` `G`
Create embedded chart	`Alt` `F1`	`Fn` `Option` `F1`
Create chart in new chart sheet	`F11`	`Fn` `F11`
Toggle Autofilter	`Ctrl` `Shift` `L`	`⌘` `Shift` `F`
Activate filter	`Alt` `↓`	`Option` `↓`
Create table	`Ctrl` `T`	`Control` `T`
Select an entire row	`Shift` `Spacebar`	`Shift` `Spacebar`
Select an entire column	`Ctrl` `Spacebar`	`Control` `Spacebar`
Select the entire worksheet	`Ctrl` `A` or `Ctrl` `Shift` `Spacebar`	`⌘` `A`
File	Windows	Mac
Create new workbook	`Ctrl` `N`	`⌘` `N`
Open workbook	`Ctrl` `O`	`⌘` `O`
Save workbook	`Ctrl` `S`	`⌘` `S`
Displays the Save As dialog	`F12`	`⌘` `Shift` `S`
Print preview and print	`Ctrl` `P` or `Ctrl` `F2`	`⌘` `P`
Close current workbook	`Ctrl` `F4`	`⌘` `W`
Close Excel	`Alt` `F4`	`⌘` `Q`
Ribbon	Windows	Mac
Expand or collapse ribbon	`Ctrl` `F1`	`⌘` `Option` `R`
Activate access keys	`Alt`
Move to next ribbon control	`Tab`	`Tab`
Activate or open selected control	`Spacebar`	`Spacebar`
Confirm control change	`Enter`	`Return`
Get help on selected control	`F1`
Drag and Drop	Windows	Mac
Drag and cut	`drag`	`drag`
Drag and copy	`Ctrl` `drag`	`Option` `drag`
Drag and insert	`Shift` `drag`	`Shift` `drag`
Drag and insert copy	`Ctrl` `Shift` `drag`	`Option` `Shift` `drag`
Drag to worksheet	`Alt` `drag`	`⌘` `drag`
Drag to duplicate worksheet	`Ctrl` `drag`	`Option` `drag`
Navigation	Windows	Mac
Move one cell right	`→`	`→`
Move one cell left	`←`	`←`
Move one cell up	`↑`	`↑`
Move one cell down	`↓`	`↓`
Move one screen right	`Alt` `PgDn`	`Fn` `Option` `↑`
Move one screen left	`Alt` `PgUp`	`Fn` `Option` `↓`
Move one screen up	`PgUp`	`Fn` `↑`
Move one screen down	`PgDn`	`Fn` `↓`
Move to right edge of data region	`Ctrl` `→`	`Control` `→`
Move to left edge of data region	`Ctrl` `←`	`Control` `←`
Move to top edge of data region	`Ctrl` `↑`	`Control` `↑`
Move to bottom edge of data region	`Ctrl` `↓`	`Control` `↓`
Move to beginning of row	`Home`	`Fn` `←`
Move to last cell in worksheet	`Ctrl` `End`	`Fn` `Control` `→`
Move to first cell in worksheet	`Ctrl` `Home`	`Fn` `Control` `←`
Turn End mode on	`End`	`Fn` `→`
Selection	Windows	Mac
Select entire row	`Shift` `Spacebar`	`Shift` `Spacebar`
Select entire column	`Ctrl` `Spacebar`	`Control` `Spacebar`
Select entire worksheet	`Ctrl` `A`	`⌘` `A`
Add non-adjacent cells to selection	`Ctrl` `Click`	`Control` `Click`
Move right between non-adjacent selections	`Ctrl` `Alt` `→`	`Control` `Option` `→`
Move left between non-adjacent selections	`Ctrl` `Alt` `←`	`Control` `Option` `←`
Toggle add to selection mode	`Shift` `F8`	`Fn` `Shift` `F8`
Cancel selection	`Esc`	`Esc`
Extend Selection	Windows	Mac
Extend selection by one cell right	`Shift` `→`	`Shift` `→`
Extend selection by one cell left	`Shift` `←`	`Shift` `←`
Extend selection by one cell up	`Shift` `↑`	`Shift` `↑`
Extend selection by one cell down	`Shift` `↓`	`Shift` `↓`
Extend the selection to the last cell right	`Ctrl` `Shift` `→`	`Control` `Shift` `→`
Extend the selection to the last cell left	`Ctrl` `Shift` `←`	`Control` `Shift` `←`
Extend the selection to the last cell up	`Ctrl` `Shift` `↑`	`Control` `Shift` `↑`
Extend the selection to the last cell down	`Ctrl` `Shift` `↓`	`Control` `Shift` `↓`
Extend selection up one screen	`Shift` `PgUp`	`Fn` `Shift` `↑`
Extend selection down one screen	`Shift` `PgDn`	`Fn` `Shift` `↓`
Extend selection to start of row	`Shift` `Home`	`Fn` `Shift` `←`
Extend selection to first cell in worksheet	`Ctrl` `Shift` `Home`	`Fn` `Control` `Shift` `←`
Extend selection to last cell in worksheet	`Ctrl` `Shift` `End`	`Fn` `Control` `Shift` `→`
Toggle extend selection mode	`F8`	`Fn` `F8`
Active Cell	Windows	Mac
Select active cell only	`Shift` `Backspace`	`Shift` `Delete`
Show the active cell on worksheet	`Ctrl` `Backspace`	`⌘` `Delete`
Move active cell clockwise in selection	`Ctrl` `.`	`Control` `.`
Move active cell down in selection	`Enter`	`Return`
Move active cell up in selection	`Shift` `Enter`	`Shift` `Return`
Move active cell right in a selection	`Tab`	`Tab`
Move active cell left in a selection	`Shift` `Tab`	`Shift` `Tab`
Select Special	Windows	Mac
Display ‘Go To’ dialog box	`Ctrl` `G`	`Control` `G`
Select cells with comments	`Ctrl` `Shift` `O`	`Fn` `Control` `Shift` `O`
Select current region around active cell	`Ctrl` `Shift` `*`	`Control` `Shift` `Spacebar`
Select current region	`Ctrl` `A`	`⌘` `A`
Select current array	`Ctrl` `/`	`Control` `/`
Select row differences	`Ctrl` `\`	`Control` `\`
Select column differences	`Ctrl` `Shift` `\|`	`Control` `Shift` `\|`
Select direct precedents	`Ctrl` `[`	`Control` `[`
Select all precedents	`Ctrl` `Shift` `{`	`Control` `Shift` `{`
Select direct dependents	`Ctrl` `]`	`Control` `]`
Select all dependents	`Ctrl` `Shift` `}`	`Control` `Shift` `}`
Select visible cells only	`Alt` `;`	`⌘` `Shift` `Z`
Cell Edit Mode	Windows	Mac
Edit the active cell	`F2`	`Control` `U`
Insert or edit comment	`Shift` `F2`	`Shift` `F2`
Cancel entry	`Esc`	`Esc`
Select one character right	`Shift` `→`	`Shift` `→`
Select one character left	`Shift` `←`	`Shift` `←`
Move one word right	`Ctrl` `→`	`Control` `→`
Move one word left	`Ctrl` `←`	`Control` `←`
Select one word right	`Ctrl` `Shift` `→`	`Control` `Shift` `→`
Select one word left	`Ctrl` `Shift` `←`	`Control` `Shift` `←`
Select to beginning of cell	`Shift` `Home`	`Fn` `Shift` `←`
Select to end of cell	`Shift` `End`	`Fn` `Shift` `→`
Delete to end of line	`Ctrl` `Delete`	`Control` `Delete`
Delete character to the left of cursor	`Backspace`	`Delete`
Delete character to the right of cursor	`Delete`	`Fn` `Delete`
Start a new line in the same cell	`Alt` `Enter`	`Control` `Option` `Return`
Entering Data	Windows	Mac
Enter and move down	`Enter`	`Return`
Enter and move up	`Shift` `Enter`	`Shift` `Return`
Enter and move right	`Tab`	`Tab`
Enter and move left	`Shift` `Tab`	`Shift` `Tab`
Complete entry and stay in same cell	`Ctrl` `Enter`	`Control` `Return`
Enter same data in multiple cells	`Ctrl` `Enter`	`Control` `Return`
Insert current date	`Ctrl` `;`	`Control` `;`
Insert current time	`Ctrl` `Shift` `:`	`Control` `Shift` `:`
Fill down from cell above	`Ctrl` `D`	`Control` `D`
Fill right from cell left	`Ctrl` `R`	`Control` `R`
Copy formula from cell above	`Ctrl` `'`	`Control` `'`
Copy value from cell above	`Ctrl` `Shift` `"`	`Control` `Shift` `"`
Add hyperlink	`Ctrl` `K`	`⌘` `K`
Display AutoComplete list	`Alt` `↓`	`Option` `↓`
Formatting	Windows	Mac
Format (almost) anything	`Ctrl` `1`	`⌘` `1`
Display Format Cells with Font tab selected	`Ctrl` `Shift` `F`
Apply format again	`F4`	`Control` `Y`
Apply or remove bold formatting	`Ctrl` `B`	`⌘` `B`
Apply or remove italic formatting	`Ctrl` `I`	`⌘` `I`
Apply or remove underscoring	`Ctrl` `U`	`⌘` `U`
Apply or remove strikethrough formatting	`Ctrl` `5`	`⌘` `Shift` `X`
Add or remove the shadow font style		`⌘` `Shift` `W`
Add or remove the outline font style		`⌘` `Shift` `D`
Align center	`Alt` `H` `A` `C`	`⌘` `E`
Align left	`Alt` `H` `A` `L`	`⌘` `L`
Align right	`Alt` `H` `A` `R`	`⌘` `R`
Indent		`⌘` `M`
Remove indent		`⌘` `Shift` `M`
Increase font size one step		`⌘` `Shift` `>`
Decrease font size one step		`⌘` `Shift` `<`
Number Formatting	Windows	Mac
Apply general format	`Ctrl` `Shift` `~`	`Control` `Shift` `~`
Apply currency format	`Ctrl` `Shift` `$`	`Control` `Shift` `$`
Apply percentage format	`Ctrl` `Shift` `%`	`Control` `Shift` `%`
Apply scientific format	`Ctrl` `Shift` `^`	`Control` `Shift` `^`
Apply date format	`Ctrl` `Shift` `#`	`Control` `Shift` `#`
Apply time format	`Ctrl` `Shift` `@`	`Control` `Shift` `@`
Apply number format	`Ctrl` `Shift` `!`	`Control` `Shift` `!`
Borders	Windows	Mac
Add border outline	`Ctrl` `Shift` `&`	`⌘` `Option` `0`
Add or remove border right	`Alt` `R`	`⌘` `Option` `→`
Add or remove border left	`Alt` `L`	`⌘` `Option` `←`
Add or remove border top	`Alt` `T`	`⌘` `Option` `↑`
Add or remove border bottom	`Alt` `B`	`⌘` `Option` `↓`
Add or remove border upward diagonal	`Alt` `D`
Add or remove border horizontal interior	`Alt` `H`
Add or remove border vertical interior	`Alt` `V`
Remove borders	`Ctrl` `Shift` `_`	`⌘` `Option` `_`
Formulas	Windows	Mac
Toggle absolute and relative references	`F4`	`⌘` `T`
Open the Insert Function Dialog Box	`Shift` `F3`	`Fn` `Shift` `F3`
Autosum selected cells	`Alt` `=`	`⌘` `Shift` `T`
Toggle formulas on and off	`Ctrl` `	`Control` `
Insert function arguments	`Ctrl` `Shift` `A`	`Control` `Shift` `A`
Enter array formula	`Ctrl` `Shift` `Enter`	`Control` `Shift` `Return`
Calculate worksheets	`F9`	`F9`
Calculate active worksheet	`Shift` `F9`	`Fn` `Shift` `F9`
Force calculate all worksheets	`Ctrl` `Alt` `F9`
Evaluate part of a formula	`F9`	`Fn` `F9`
Expand or collapse the formula bar	`Ctrl` `Shift` `U`	`Control` `Shift` `U`
Display function arguments dialog box	`Ctrl` `A`	`Control` `A`
Name Manager	`Ctrl` `F3`	`Control` `L`
Define name using row and column labels	`Ctrl` `Shift` `F3`	`Control` `Shift` `F3`
Paste name into formula	`F3`
Accept function with autocomplete	`Tab`	`↓` `Tab`
Pivot Tables	Windows	Mac
Select entire pivot table	`Ctrl` `A`	`⌘` `A`
Toggle pivot table field checkbox	`Spacebar`	`Spacebar`
Group pivot table items	`Alt` `Shift` `→`	`⌘` `Shift` `K`
Ungroup pivot table items	`Alt` `Shift` `←`	`⌘` `Shift` `J`
Hide pivot table item	`Ctrl` `-`	`Ctrl` `-`
Create pivot chart on same worksheet	`Alt` `F1`
Create pivot chart on new worksheet	`F11`	`Fn` `F11`
Workbook	Windows	Mac
Insert new worksheet	`Shift` `F11`	`Shift` `F11`
Go to next worksheet	`Ctrl` `PgDn`	`Fn` `Control` `↓`
Go to previous worksheet	`Ctrl` `PgUp`	`Fn` `Control` `↑`
Move to next pane	`F6`	`F6`
Move to previous pane	`Shift` `F6`	`Shift` `F6`
Go to next workbook	`Ctrl` `Tab`	`Control` `Tab`
Go to previous workbook	`Ctrl` `Shift` `Tab`	`Control` `Shift` `Tab`
Display control menu	`Alt` `Spacebar`
Minimize current workbook window	`Ctrl` `F9`	`⌘` `M`
Maximize current workbook window	`Ctrl` `F10`
Dialog Boxes	Windows	Mac
Move to next control	`Tab`	`Tab`
Move to previous control	`Shift` `Tab`	`Shift` `Tab`
Move to next tab	`Ctrl` `Tab`	`Control` `Tab`
Move to previous tab	`Ctrl` `Shift` `Tab`	`Control` `Shift` `Tab`
Accept and apply	`Enter`	`Return`
Check and uncheck box	`Spacebar`	`Spacebar`
Cancel and close the dialog box	`Esc`	`Esc`
Grid Operations	Windows	Mac
Display Insert Dialog box	`Ctrl` `Shift` `+`	`Control` `I`
Insert rows	`Ctrl` `Shift` `+`	`Control` `I`
Insert columns	`Ctrl` `Shift` `+`	`Control` `I`
Display Delete dialog box	`Ctrl` `-`	`Control` `-`
Delete rows	`Ctrl` `-`	`Control` `-`
Delete columns	`Ctrl` `-`	`Control` `-`
Delete cells	`Ctrl` `-`	`Control` `-`
Delete contents of selected cells	`Delete`	`Fn` `Delete`
Hide columns	`Ctrl` `0`	`Control` `0`
Hide rows	`Ctrl` `9`	`Control` `9`
Unhide rows	`Ctrl` `Shift` `9`	`Control` `Shift` `9`
Unhide columns	`Ctrl` `Shift` `0`	`Control` `Shift` `0`
Group rows or columns	`Alt` `Shift` `→`	`⌘` `Shift` `K`
Ungroup rows or columns	`Alt` `Shift` `←`	`⌘` `Shift` `J`
Open Group Dialog Box	`Alt` `Shift` `→`	`⌘` `Shift` `K`
Open Ungroup Dialog Box	`Alt` `Shift` `←`	`⌘` `Shift` `J`
Hide or show outline symbols	`Ctrl` `8`	`Control` `8`
VBA Editor	Windows	Mac
Help	`F1`
Object Browser	`F2`
Find Next	`F3`
Properies Window	`F4`
Run	`F5`
Switch Split Windows	`F6`
Goto Window Of Object	`F7`
Step	`F8`
Breakpoint	`F9`
Activate Menu Bar	`F10`
Toggle Insert Mode	`Insert`
Delete	`Delete`
Beginning Of Line	`Home`
End Of Line	`End`
Page Up	`PgUp`
Page Down	`PgDn`
Left	`←`
Right	`→`
Up	`↑`
Down	`↓`
Indent	`Tab`
New Line	`Enter`
Delete Prev Char	`BackSpace`
Procedure Definition	`Shift` `F2`
Find Prev	`Shift` `F3`
Find Next	`F3`
Procedure Step	`Shift` `F8`
Quick Watch	`Shift` `F9`
Show Right Click Menu	`Shift` `F10`
Paste	`Shift` `Insert`
Select To Start Of Line	`Shift` `Home`
Select To End Of Line	`Shift` `End`
Select To Top Of Module	`Shift` `PgUp`
Select To End Of Module	`Shift` `PgDn`
Extend Selection Left 1 Char	`Shift` `←`
Extend Selection Right 1 Char	`Shift` `→`
Extend Selection Up	`Shift` `↑`
Extend Selection Down	`Shift` `↓`
Un-indent	`Shift` `Tab`
Focus To Object Box	`Ctrl` `F2`
Close Window	`Ctrl` `F4`
Run To Cursor	`Ctrl` `F8`
Activate Menu Bar	`Ctrl` `F10`
Select All Text	`Ctrl` `A`
Copy	`Ctrl` `C`
Export Module	`Ctrl` `E`
Find	`Ctrl` `F`
Immediate Window	`Ctrl` `G`
Replace	`Ctrl` `H`
Turn On Quick Info	`Ctrl` `I`
List Members	`Ctrl` `J`
Show Call Stack	`Ctrl` `L`
Import File	`Ctrl` `M`
New Line	`Ctrl` `N`
Print	`Ctrl` `P`
Project Window	`Ctrl` `R`
Save	`Ctrl` `S`
Show Available Components	`Ctrl` `T`
Paste	`Ctrl` `V`
Cut	`Ctrl` `X`
Cut Entire Line	`Ctrl` `Y`
Undo	`Ctrl` `Z`
Copy	`Ctrl` `Insert`
Delete To End Of Word	`Ctrl` `Delete`
Top Of Module	`Ctrl` `Home`
End Of Module	`Ctrl` `End`
Top Of Current Procedure	`Ctrl` `Page Up`
End Of Current Procedure	`Ctrl` `Page Down`
Left Word	`Ctrl` `Left Arrow`
Right Word	`Ctrl` `Right Arrow`
Previous Procedure	`Ctrl` `Up Arrow`
Next Procedure	`Ctrl` `Down Arrow`
Turn On Complete Word	`Ctrl` `Spacebar`
Cycle Windows	`Ctrl` `Tab`
Delete To Start Of Word	`Ctrl` `BackSpace`
Close VBE	`Alt` `F4`
Run Error Handler	`Alt` `F5`
Switch Between Last 2 Windows	`Alt` `F6`
Step Error Handler	`Alt` `F7`
Return To Application	`Alt` `F11`
Add-Ins Menu	`Alt` `A`
Debug Menu	`Alt` `D`
Edit Menu	`Alt` `E`
File Menu	`Alt` `F`
Help Menu	`Alt` `H`
Insert Menu	`Alt` `J`
Format Menu	`Alt` `O`
Close & Return	`Alt` `Q`
Run Menu	`Alt` `R`
Tools Menu	`Alt` `T`
View Menu	`Alt` `V`
Window Menu	`Alt` `W`
System Menu	`Alt` `Spacebar`
Cycle Applications	`Alt` `Tab`
Undo	`Alt` `BackSpace`
Previous Position	`Ctrl` `Shift` `F2`
Clear All Breakpoints	`Ctrl` `Shift` `F9`
Turn On Param Info	`Ctrl` `Shift` `I`
Turn On List Properties	`Ctrl` `Shift` `J`
Other	Windows	Mac
Open Spelling dialog box	`F7`	`F7`
Open Thesaurus dialog box	`Shift` `F7`	`Shift` `F7`
Open Macro dialog box	`Alt` `F8`	`Fn` `Option` `F8`
Open VBA Editor	`Alt` `F11`	`Fn` `Option` `F11`
Duplicate object	`Ctrl` `D`	`⌘` `D`
Snap to grid	`Alt`	`⌘`
Hide or show objects	`Ctrl` `6`	`Control` `6`
Display Modify Cell Style dialog box	`Alt` `'`	`⌘` `Shift` `L`

Excel Keyboard Shortcuts