Spreadsheets: Getting Started, Part V

 Back     Forward    "Getting Started" Home    Excel Review Home

 

V. Moving and Selecting
    Moving Around the Worksheet
    Specifying a Range
    Selecting a Range for Data Entry
    For More Information

 

Moving Around the Worksheet

Use the scroll bars at the right and bottom of the workbook window to move quickly around the worksheet.

To go to a specific cell, hit the F5 key to get the Go To dialog box. In the Reference area, enter the reference of the cell you want to go to and click OK. Excel closes the dialog box and makes the cell you named the current cell.

In the Go To: area of the dialog box, Excel keeps track of the last locations you asked for, in case you want to return to them.

If you've named cells or ranges in your worksheet you can enter a name instead of a cell or range reference.

CTRL+Home puts you in the upper-left-hand corner of your worksheet: cell A1.

Return to Top

 

Specifying a Range

You may need to specify a range by typing, and not just by selecting the range with the mouse. This is especially useful, for example, if the range is a large one extending past the borders of your display and so not easy to select by dragging. To specify a range by typing, indicate the cell reference of the cell at the top left corner of the range. Type a colon. Then indicate the cell at the bottom right corner of the range. Here's an example of typing in a range specification: A1:B5

You can also select a range by using the Go To dialog box (F5) and typing in a range specification instead of just a single cell reference.

Return to Top

 

Selecting a Range for Data Entry

If you need to enter a lot of data in contiguous cells of your worksheet you can speed up operations by selecting the range where the data will be before you begin entering data. Then when you enter data in the first cell of the range you can just hit the enter key to move to the next cell instead of hitting the enter key and having to use an arrow key or the mouse to move to the next cell. Within the range you specify, Excel by default moves down each column and then across.

You can change the default setting for your installation of Excel by clicking Tools, Options, Edit and selecting an option from "Move Selection after Enter Direction".

 

Return to Top

 

For More Information

Click Help on the top-level menu. Select Contents and Index, select the Contents tab and click Entering Data and Selecting Cells.

Return to Top