Datasheet

Shortcut Action
Ctrl+F Find
Ctrl+G or F5 Go To
Ctrl+H Replace
Ctrl+I Apply or remove italic formatting
Ctrl+O or Ctrl+F12 Open a document
Ctrl+P Print
Ctrl+S or Shift+F12 Save
Ctrl+U Apply or remove underlining
Ctrl+V Paste
Ctrl+W or Ctrl+F4 Close the active workbook
Crtl+X Cut
Ctrl+Y or F4 Repeat the last action
Ctrl+Z Undo the last action
F1 Display the help viewer
Ctrl+F1 Hide or display the Ribbon commands
F2 Enable editing within the active cell
With more than 17 billion cells in a worksheet, you need ways to move to spe-
cific cells. Fortunately, Excel provides you with many techniques to move
around a worksheet. As always, you can use either your mouse or the keyboard
on your navigational journeys. The following table lists the keystrokes that
enable you to move through a worksheet.
Keys Action
Up arrow Moves the active cell one row up
Down arrow Moves the active cell one row down
Left arrow Moves the active cell one column to the left
Right arrow Moves the active cell one column to the right
PgUp Moves the active cell one screen up
PgDn Moves the active cell one screen down
Alt+PgDn Moves the active cell one screen right
Alt+PgUp Moves the active cell one screen left
Home Moves the active cell to the first column of the row that the active cell
is currently in
Navigating with the Mouse and Keyboard 7
cont.
03_046716 ch01.qxp 11/16/06 6:40 PM Page 7