• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Parts of the Excel Window > Moving Within a Worksheet

Moving Within a Worksheet

Once the worksheet you want to work on is displayed, you'll need some way of moving to the various cells within the worksheet. Keep in mind that the part of the worksheet displayed on-screen is only a small piece of the actual worksheet. To move around the worksheet with your keyboard, use the keys listed in Table 2.1.

Table 2.1. Moving Around a Worksheet with the Keyboard
Press ThisTo Move…
⇑ ⇓ ⟸ ⟹One cell in the direction of the arrow.
Ctrl+⇑ or Ctrl+⇓To the top or bottom of a data region (the area of a worksheet that contains data).
Ctrl+⟸ or Ctrl+⟹To the leftmost or rightmost cell in a data region.
PgUpUp one screen.
PgDnDown one screen.
HomeLeftmost cell in a row.
Ctrl+HomeUpper-left corner of a worksheet.
Ctrl+EndLower-right corner of the data area.
End+⇑, End+⇓, End+⟸, End+⟹If the active cell is blank, moves in the direction of the arrow to the first cell that contains data. If the active cell contains an entry, moves in the direction of the arrow to the last cell that has an entry.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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