Microsoft Office Tutorials and References
In Depth Information
Excel window components
The cell in which you are currently working. A dark border outlining the cell identifies the active cell.
The letters that appear along the top of the worksheet window. Columns are listed alphabetically from A to IV
(a total of 256 possible columns).
The bar located immediately below the toolbars that displays the contents of the active cell. As you type or edit
data, the changes appear in the Formula bar.
The box that displays the cell reference, or column and row location, of the active cell in the workbook window.
The numbers that appear along the left side of the worksheet window. Rows are numbered consecutively
from 1 to 65,536.
Select All button
Square button located at the intersection of the column and row headings that you click to select the entire contents
of the worksheet.
Tabs located at the bottom of each worksheet in the workbook that display the names of the sheets. To move between
worksheets, click the appropriate sheet tab.
The pane that provides access to frequently used tasks. When you start Excel, the Getting Started task pane appears.
The task pane disappears once you open a workbook. There are several task-specific panes available in Excel.
Series of buttons located to the left of the sheet tabs that you can click to move between worksheets in the
Toolbars that provide quick access to commonly used commands. The Standard toolbar contains buttons for the most
frequently used program commands, such as Save and Print. The Formatting toolbar contains buttons used to format
the appearance of the workbook, such as Bold and Italics. Additional toolbars are available.
Now that you are familiar with the basic layout of an Excel window, you can try mov-
ing around within the workbook.
Navigating a Worksheet
Excel provides several ways of moving around within a worksheet. You can use your
mouse to click a cell to make it the active cell, or you can use the vertical and horizontal
scroll bars to display the area of the worksheet containing the cell you want to make
active. You can also navigate a worksheet by using your keyboard. Figure 1-5 describes
some of these keyboard shortcuts that Excel provides so you can move from cell to cell
within the worksheet quickly and easily.
Shortcut keys for navigating a worksheet
Moves the active cell up, down, left, or right one cell
Ctrl + Home
Moves the active cell to cell A1
Ctrl + End
Moves to the last cell in the worksheet that contains data
Moves the active cell down one cell, or moves to the start of the next row in the
selected range of cells
Opens the Go To dialog box, in which you specify the cell you want to move to
Moves the active cell to column A of the current row
Page Up, Page Down
Moves the active cell up or down one full screen
Tab, Shift + Tab
Moves the active cell to the right or left one cell
Try navigating the worksheet now.