Appendix D: Excel Shortcut Keys
953
TABLE D.6Other 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 File ➪ Open
Ctrl+P Equivalent to File ➪ 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 File ➪ 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 Undo59_474877-bapp04.indd 95359_474877-bapp04.indd 953 3/29/10 11:47 PM3/29/10 11:47 PM