Datasheet

Discovering Some Useful
Shortcut Keys
Excel has no shortage of shortcut keys. Your productivity is sure to increase if you take the
time to learn the shortcut keys for commands that you use frequently. In the following
table, I list some of the most useful shortcut keys. This list is certainly not an exhaustive
one — it describes just the commands that I find most useful.
Shortcut What You Can Do with It
F11 Create a new chart on a separate chart sheet (of the default chart type) by
using data in the selected range
Alt+F1 Create a new, embedded chart (of the default chart type) by using the data
in the selected range
F5 Display the Go To dialog box
Alt Display the keytips for the Ribbon commands so that you can access the
commands by using letters on the keyboard
Shift+F2 Edit the comment in the active cell or insert a comment if the cell doesn’t
have one
Shift+F10 Display the shortcut menu for the selected item
Ctrl+F6 Activate the next window
Ctrl+PgUp Activate the previous sheet in the workbook
Ctrl+PgDn Activate the next sheet in the workbook
Alt+Ctrl+V Display the Paste Special dialog box
Alt+= Perform the equivalent of clicking the AutoSum button
Ctrl+B Make the selected cells bold
Ctrl+C Copy the selected cells
Ctrl+D Fill down
Ctrl+F Display the Find dialog box
Ctrl+H Display the Replace dialog box
Ctrl+I Make the selected cells italic
Ctrl+N Create a new default workbook
Ctrl+R Fill to the right
Ctrl+S Save the active workbook
Tip 6: Discovering Some Useful Shortcut Keys
24
04_137666 ch01.qxp 5/22/07 7:31 PM Page 24