Formatting I
^1
Format cells dialog box
^5
Strikethrough
^B
Bold
^I
Italic
^U
Underline
Formatting II
^⇧`
General format
^⇧!
Format cell to two decimal places
^⇧@
Format cell to time
^⇧#
Format cell to date
^⇧$
Format cell to currency
^⇧%
Format cell to percentage
^⇧^
Format cell to scientific notation
^⇧&
Draws outline around your selection
Cell Selection
^A
Select All Cells in range
⇧F8
Add to selection
^SPACE
Select the current column
⇧SPACE
Select the current row
⇧HOME
Select to beginning of row
⇧END
Select to last used cell in row
^⇧HOME
Select to beginning of worksheet
^⇧END
Select to end of worksheet
^⇧*
Select data region surrounding active cell
^⇧O
Select all cell containing a comment
^[
Select cells that formula directly references
^]
Select formula that references the active cell
Data I
^⇧:
Insert Current Time
^;
Insert Current Date
^C
Copy
^V
Paste
^X
Cut
^Y
Repeat
^Z
Undo
⇧F2
Edit cell comment
^BACKSPACE
Display the active cell
Data II
⌥IC
Insert column
⌥IR
Insert row
^D
Fill Down
^R
Fill Right
^⇧+
Insert Cells, Rows, Columns
^⇧F3
Create name by using names of row and column labels
F2
Edit
Workbooks
^0
Hide columns
^9
Hide rows
^F10
Maximize or restore window
^F9
Minimize workbook
^⇧(
Unhide rows
F7
Spell check
Formulas
⌥=
AutoSum
^'
Copy formula from cell above
^⌥F9
Forces full calculation of all worksheets
^⌥⇧F9
Forces calculation with dependency tree rebuild
^⇧A
Insert argument names into formula
F3
Paste Name
⇧F3
Paste function into formula
^⇧"
Copy value from cell above
=
Begin a formula
^`
Toggle display of formula vs cell values
General
⌥F1
Insert a Chart sheet
⌥F11
Open Visual Basic Editor
⌥F8
Macro dialog box
⌥⇧F2
Save Workbook
^F11
Inset 4.0 Macro sheet
F1
Help
F4
Repeat last action
⇧F10
Display shortcut menu
Navigation
^END
Move to last used cell in a worksheet
^G
Goto
^HOME
Move to the first non-header cell of the sheet
F6
Next Pane
⇧↵
Go to previous cell
⇧F6
Previous Pane
HOME
Move to beginning of row
Move down a cell in selected range
⇧↵
Move up a cell in selected range
^.
Move from corner cell to corner cell in range
Go to next cell
Misc I
F10
Activate menu
⌥DOWN
Display AutoComplete list
^6
Show/Hide objects
^7
Show/Hide Standard toolbar
^8
Toggle Outline symbols
^↵
Fill the selected cell range with the current entry.
^F
Find
^F12
File Open
Misc II
^H
Replace
^O
Open
F8
Extend mode
F9
Recalculate all workbooks
^⇧F
Font Drop Down List
^⇧FF
Fill tab of Format Cell Dialog box
^⇧P
Point size Drop Down List
⇧F4
Find Next
⇧F9
Re-calculate active worksheet
TAB
Next tool
