Tycom Limited

Excel Shortcuts

Open options	Alt F T	⌘ ,
Open help	F1	⌘ /
Undo last action	Ctrl Z	⌘ Z
Redo last action	Ctrl Y	⌘ Y
Copy selected cells	Ctrl C	⌘ C
Repeat last action	F4	⌘ Y
Cut selected cells	Ctrl X	⌘ X
Paste content from clipboard	Ctrl V	⌘ V
Display the Paste Special dialog box	Ctrl Alt V	⌘ ⌃ V
Display find and replace	Ctrl F	⌘ F
Display find and replace, replace selected	Ctrl H	⌃ H
Find next match	Shift F4	⌘ G
Find previous match	Ctrl Shift F4	⌘ ⇧ G
Create embedded chart	Alt F1	Fn ⌥ F1
Create chart in new worksheet	F11	Fn F11

Move one cell right	→	→
Move one cell left	←	←
Move one cell up	↑	↑
Move one cell down	↓	↓
Move one screen right	Alt Pg Dn	Fn ⌥ ↓
Move one screen left	Alt Pg Up	Fn ⌥ ↑
Move one screen up	Pg Up	Fn ↑
Move one screen down	Pg Dn	Fn ↓
Move to right edge of data region	Ctrl →	⌃ →
Move to left edge of data region	Ctrl ←	⌃ ←
Move to top edge of data region	Ctrl ↑	⌃ ↑
Move to bottom edge of data region	Ctrl ↓	⌃ ↓
Move to beginning of row	Home	Fn ←
Move to last cell in worksheet	Ctrl End	Fn ⌃ →
Move to first cell in worksheet	Ctrl Home	Fn ⌃ ←
Turn End mode on	End	Fn →
Go back to hyperlink	Ctrl G Enter	⌃ G Return

Select entire row	Shift Space	⇧ Space
Select entire column	Ctrl Space	⌃ Space
Select entire worksheet	Ctrl A	⌘ A
Add adjacent cells to selection	Shift Click	⇧ Click
Add non-adjacent cells to selection	Ctrl Click	⌘ Click
Same selection in next column		⌥ Tab
Same selection in previous column		⌥ ⇧ Tab
Move right between non-adjacent selections	Ctrl Alt →	⌃ ⌥ →
Move left between non-adjacent selections	Ctrl Alt ←	⌃ ⌥ ←
Toggle add to selection mode	Shift F8	Fn ⇧ F8
Cancel selection	Esc	Esc

Extend selection by one cell right	Shift →	⇧ →
Extend selection by one cell left	Shift ←	⇧ ←
Extend selection by one cell up	Shift ↑	⇧ ↑
Extend selection by one cell down	Shift ↓	⇧ ↓
Extend the selection to the last cell right	Ctrl Shift →	⌃ ⇧ →
Extend the selection to the last cell left	Ctrl Shift ←	⌃ ⇧ ←
Extend the selection to the last cell up	Ctrl Shift ↑	⌃ ⇧ ↑
Extend the selection to the last cell down	Ctrl Shift ↓	⌃ ⇧ ↓
Extend selection up one screen	Shift PgUp	Fn ⇧ ↑
Extend selection down one screen	Shift PgDn	Fn ⇧ ↓
Extend selection right one screen	Alt Shift PgDn	Fn ⇧ ⌥ ↓
Extend selection left one screen	Alt Shift PgUp	Fn ⇧ ⌥ ↑
Extend selection to start of row	Shift Home	Fn ⇧ ←
Extend selection to first cell in worksheet	Ctrl Shift Home	Fn ⌃ ⇧ ←
Extend selection to last cell in worksheet	Ctrl Shift End	Fn ⌃ ⇧ →
Toggle extend selection mode	F8	Fn F8

Display 'Go To' dialog box	Ctrl G	⌃ G
Select cells with comments	Ctrl Shift O	Fn ⌃ ⇧ O
Select current region around active cell	Ctrl Shift *	⇧ ⌃ Space
Select current region	Ctrl A	⌘ A
Select current array	Ctrl /	⌃ /
Select row differences	Ctrl \	⌃ \
Select column differences	Ctrl Shift \|	⌃ ⇧ \|
Select direct precedents	Ctrl [	⌃ [
Select all precedents	Ctrl Shift {	⌃ ⇧ {
Select direct dependents	Ctrl ]	⌃ ]
Select all dependents	Ctrl Shift }	⌃ ⇧ }
Select visible cells only	Alt ;	⌘ ⇧ Z

Edit the active cell	F2	⌃ U
Insert or edit comment	Shift F2	Fn ⇧ F2
Cancel entry	Esc	Esc
Select one character right	Shift →	⇧ →
Select one character left	Shift ←	⇧ ←
Move one word right	Ctrl →	⌃ →
Move one word left	Ctrl ←	⌃ ←
Select one word right	Ctrl Shift →	⌃ ⇧ →
Select one word left	Ctrl Shift ←	⌃ ⇧ ←
Select to beginning of cell	Shift Home	Fn ⇧ ←
Select to end of cell	Shift End	Fn ⇧ →
Delete to end of line	Ctrl Delete	⌃ 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	⌃ ⌥ Return

Enter and move down	Enter	Return
Enter and move up	Shift Enter	⇧ Return
Enter and move right	Tab	Tab
Enter and move left	Shift Tab	⇧ Tab
Complete entry and stay in same cell	Ctrl Enter	⌃ Return
Enter same data in multiple cells	Ctrl Enter	⌃ Return
Insert current date	Ctrl ;	⌃ ;
Insert current time	Ctrl Shift :	⌘ ;
Fill down from cell above	Ctrl D	⌃ D
Fill right from cell left	Ctrl R	⌃ R
Copy formula from cell above	Ctrl '	⌃ '
Copy value from cell above	Ctrl Shift "	⌃ ⇧ "
Add hyperlink	Ctrl K	⌘ K
Display AutoComplete list	Alt ↓	⌥↓
Flash fill	Ctrl E

Format (almost) anything	Ctrl 1	⌘ 1
Display Format Cells with Font tab selected	Ctrl Shift F	⌃ ⇧ F
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	⌘ ⇧ X
Add or remove the shadow font style		⌘ ⇧ W
Add or remove the outline font style		⌘ ⇧ D
Align center	Alt H A C	⌘ E
Align left	Alt H A L	⌘ L
Align right	Alt H A R	⌘ R
Indent	Alt H 6	⌃ ⌥ Tab
Remove indent	Alt H 5	⌃ ⌥ ⇧ Tab
Increase font size one step	Alt H F G	⌘ ⇧ >
Decrease font size one step	Alt H F K	⌘ ⇧ <

Toggle absolute and relative references	F4	⌘ T
Open the Insert Function Dialog Box	Shift F3	Fn ⇧ F3
Autosum selected cells	Alt =	⌘ ⇧ T
Toggle formulas on and off	Ctrl `	⌃ `
Insert function arguments	Ctrl Shift A	⌃ ⇧ A
Enter array formula	Ctrl Shift Enter	⌃ ⇧ Return
Calculate worksheets	F9	Fn F9
Calculate active worksheet	Shift F9	Fn ⇧ 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	⌃ ⇧ U
Display function arguments dialog box	Ctrl A	⌃ A
Define name	Ctrl F3	Fn ⌃ F3
Define name using row and column labels	Ctrl Shift F3	Fn ⌃ ⇧ F3
Paste name into formula	F3
Accept function with autocomplete	Tab	↓ Tab

Display Insert Dialog box	Ctrl Shift +	⌘ ⇧ +
Insert rows	Ctrl Shift +	⌘ ⇧ +
Insert columns	Ctrl Shift +	⌘ ⇧ +
Display Delete dialog box	Ctrl -	⌘ -
Delete rows	Ctrl -	⌘ -
Delete columns	Ctrl -	⌘ -
Delete cells	Ctrl -	⌘ -
Delete contents of selected cells	Delete	Fn Delete
Hide columns	Ctrl 0	⌃ 0
Hide rows	Ctrl 9	⌃ 9
Unhide rows	Ctrl Shift 9	⌃ ⇧ 9
Unhide columns	Ctrl Shift 0	⌃ ⇧ 0
Group rows or columns	Alt Shift →	⌘ ⇧ K
Ungroup rows or columns	Alt Shift ←	⌘ ⇧ J
Open Group Dialog Box	Alt Shift →	⌘ ⇧ K
Open Ungroup Dialog Box	Alt Shift ←	⌘ ⇧ J
Hide or show outline symbols	Ctrl 8	⌃ 8
Zoom in	Ctrl Alt +	⌥ ⌘ +
Zoom out	Ctrl Alt -	⌥ ⌘ -

Insert new worksheet	Shift F11	fn ⇧ F11
Go to next worksheet	Ctrl PgDn	Fn ⌃ ↓
Go to previous worksheet	Ctrl PgUp	Fn ⌃ ↑
Move to next pane	F6	Fn F6
Move to previous pane	Shift F6	Fn ⇧ F6
Go to next workbook	Ctrl Tab	⌃ Tab
Go to previous workbook	Ctrl Shift Tab	⌃ ⇧ Tab
Minimize current workbook window	Ctrl F9	⌘ M
Maximize current workbook window	Ctrl F10	fn ⌃ F10
Select adjacent worksheets	Shift Click	⇧ Click
Select non-adjacent worksheets	Ctrl Click	⌘ Click
Toggle scroll lock	ScrLk	Fn ⇧ F14
Toggle full screen	Ctrl Shift F1	⌃ ⌘ F