Microsoft Office Tutorials and References
In Depth Information
Excel’s Ribbon User Interface
What to do in the Worksheet area
The Worksheet area is where most of the Excel spreadsheet action takes
place because it’s the place that displays the cells in different sections of the
current worksheet and it’s right inside the cells that you do all your
spreadsheet data entry and formatting, not to mention a great deal of your editing.
To enter or edit data in a cell, that cell must be current. Excel indicates that a
cell is current in three ways:
✓ The cell cursor — the dark green border surrounding the cell’s entire
perimeter — appears in the cell.
✓ The address of the cell appears in the Name box of the Formula bar.
✓ The cell’s column letter(s) and row number are shaded in the column
headings and row headings that appear at the top and left of the
Worksheet area, respectively.
Moving around the worksheet
An Excel worksheet contains far too many columns and rows for all a
worksheet’s cells to be displayed at one time, regardless of how large your
computer’s monitor screen is or how high the screen resolution. (After all, we’re
talking 17,179,869,184 cells total!) Therefore, Excel offers many methods for
moving the cell cursor around the worksheet to the cell where you want to
enter new data or edit existing data:
✓ Click the desired cell — assuming that the cell is displayed within the
section of the sheet visible in the Worksheet area — either by clicking it
with your mouse or tapping it on your touchscreen.
Click the Name box, then type the address of the desired cell and press
the Enter key.
✓ Press F5 to open the Go To dialog box, type the address of the desired
cell into its Reference text box, and then click OK.
✓ Use the cursor keys, as shown in Table 1-1 to move the cell cursor to the
✓ Use the horizontal and vertical buttons located at the ends of the scroll
bars found at the bottom and right edge of the Worksheet area to move
to the part of the worksheet that contains the desired cell and then click
or tap the cell to put the cell cursor in it.