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

Chapter 9. Entering Information > Moving Around in a Worksheet

Moving Around in a Worksheet

Excel windows work like most others in Macintosh applications, with some additional help to get where you want to go. Note the names of the columns (letters) and names of the rows (numbers). Specifying the column and row (for example, G4) uniquely identifies a cell. This is the cell address.

To move to a cell:

1.
Click in the cell (Figure 9.1). The cell address appears in the name box, and the corresponding column name and row name are highlighted.

Figure 9.1. Click the cell you want to enter.


or

Use keyboard shortcuts to move the cell pointer to the cell (Table 9.1).

or

Click the name box and type the destination cell address (Figure 9.2), then press or .

Figure 9.2. Click the name box, and type a cell address.


2.
The cell you move to becomes the active cell. The new cell address appears in the name box, and the corresponding column name and row name are highlighted.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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