Other Shortcut Keys

Key(s)	What It Does
Ctrl+F1	Toggles the display of the Ribbon
Alt+=	Inserts the AutoSum formula
Alt+Backspace	Equivalent to Undo
Alt+Enter	Starts a new line in the current cell
Ctrl+;	Enters the current date
Ctrl+:	Enters the current time
Ctrl+0 (zero)	Hides columns
Ctrl+6	Cycles among various ways of displaying objects on a worksheet
Ctrl+8	Toggles the display of outline symbols
Ctrl+9	Hides rows
Ctrl+[	Selects direct precedent cells
Ctrl+]	Selects directly dependent cells
Ctrl+C	Equivalent to Home => Clipboard => Copy
Ctrl+D	Equivalent to Home => Editing => Fill => Down
Ctrl+F	Equivalent to Home => Editing => Find & Select => Find
Ctrl+H	Equivalent to Home => Editing => Find & Select => Replace
Ctrl+K	Equivalent to Insert => Links => Hyperlink
Ctrl+N	Creates a new workbook
Ctrl+O	Equivalent to Office => Open
Ctrl+P	Equivalent to Office => Print
Ctrl+R	Equivalent to Home => Editing => Fill => Fill Right
Ctrl+T	Equivalent to Insert => Tables => Table
Ctrl+Shift+T	Toggles the Total row in a table
Ctrl+Shift+L	Toggles the Autofilter controls in a table
Ctrl+S	Equivalent to Office => Save
Ctlr+Alt+V	Equivalent to Home => Clipboard => Paste => Paste Special
Ctrl+Shift+(	Unhides rows in the selection
Ctrl+Shift+)	Unhides columns in the selection
Ctrl+Shift+A	Inserts the argument names and parentheses for the function (after you type a valid function name in a formula)
Ctrl+V	Equivalent to Home => Clipboard => Paste
Ctrl+X	Equivalent to Home => Clipboard => Cut
Ctrl+Z	Undo

Function Keys

Key(s)	What It Does
F1	Displays Help
Alt+F1	Inserts default chart object that uses the selected range
Alt+Shift+ F1	Inserts a new worksheet
F2	Edits the active cell
Shift+F2	Edits a cell comment
Alt+F2	Equivalent to Office => Save As
Alt+Shift+F2	Equivalent to Office => Save
F3	Pastes a name into a formula
Shift+F3	Pastes a function into a formula
Ctrl+F3	Equivalent to Formulas => Defined Names => Name Manager
Ctrl+Shift+F3	Equivalent to Formulas => Defined Names@>Create From Selection
F4	Repeats the last action
Shift+F4	Repeats the last Find (Find Next)
Ctrl+F4	Closes the window
Alt+F4	Equivalent to Office => Exit Excel
F5	Equivalent to Home => Editing => Find & Select => Go To
Shift+F5	Equivalent to Home => Editing => Find & Select => Find
Ctrl+F5	Restores a minimized or maximized workbook window
Alt+F5	Refreshes active query or pivot table
F6	Moves to the next pane
Shift+F6	Moves to the previous pane
Ctrl+F6	Activates to the next window
Ctrl+Shift+F6	Activates the previous workbook window
F7	Equivalent to Review => Proofing => Spelling
Ctrl+F7	Allows moving the window with the arrow keys
F8	Extends a selection (toggle)
Shift+F8	Adds to the selection (toggle)
Ctrl+F8	Allows resizing the window with the arrow keys
Alt+F8	Equivalent to Developer => Code => Macros
F9	Calculates all sheets in all open workbooks
Shift+F9	Calculates the active worksheet
Ctrl+Alt+F9	Global calculation
Ctrl+F9	Minimizes the workbook
F10	Displays keytips for the Ribbon
Shift+F10	Displays a shortcut menu for the selected object (equivalent to right-clicking)
Ctrl+F10	Maximizes or restores the workbook window
F11	Creates a chart in a chart sheet
Shift+F11	Inserts a new worksheet
Ctrl+F11	Inserts an Excel 4.0 macro sheet
Alt+F11	Equivalent to Developer => Code => Visual Basic
F12	Equivalent to Office => Save
Shift+F12	Equivalent to Office => Save
Ctrl+F12	Equivalent to Office => Open
Ctrl+Shift+F12	Equivalent to Office => Print