• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Moving from Cell to Cell

To enter data in the various cells that make up a worksheet, you must have a way to move from one cell to another. The most intuitive method is to point and click. Using your mouse, position the mouse pointer over the desired cell and click the left mouse button. The most intuitive method, however, is not always the fastest. As you type entries, your keyboard acts as a more efficient navigational instrument. Table 4.1 lists the various keys you can use to move around in a worksheet.

Table 4.1. Keystrokes for Navigating a Worksheet
PressTo Move
EnterOne cell down after accepting the entry you just typed.
TabOne cell to the right after accepting the entry you just typed.
One cell down.
One cell up.
One cell to the left.
One cell to the right.
Ctrl+↑To the top of a data region (an area of a worksheet that contains entries).
Ctrl+↓To the bottom of a data region.
Ctrl+←To the leftmost cell that contains an entry in a data region.
Ctrl+→To the rightmost cell that contains an entry in a data region.
PgUpUp one screen
PgDnDown one screen.
HomeTo the leftmost cell in a row.
Ctrl+HomeTo the upper-left corner of a worksheet.
Ctrl+EndTo the lower-right corner of the area of a worksheet that contains data.
End, ↑Up to the next cell that contains an entry. (Press and release the End key and then press the arrow key.)
End, ↓Down to the next cell that contains an entry. (Press and release the End key and then press the arrow key.)
End, ←Left to the next cell that contains an entry. (Press and release the End key and then press the arrow key.)
End, →Right to the next cell that contains an entry. (Press and release the End key and then press the arrow key.)



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint