Basic Navigation in Microsoft Excel 2007

The Excel Window When you open a new workbook in Excel, the program opens a blank workbook consisting of 3 worksheets. An Excel workbook is the equivalent of a Word document, and each worksheet within the workbook is equivalent to a page in your Word document.

Using the Scrollbars You can navigate within a worksheet using the vertical or horizontal scrollbars.

Worksheet Tabs You can move from one worksheet to another by using the worksheet tabs at the bottom left of your Excel window. The highlighted or white tab is the active worksheet.

Cell References The location of a cell is called a cell reference. This reference consists of a letter indicating the column and a number indicating the row. The reference for this cell is C4 because it is in column C and row 4.

Using Cell References to Move Around in a Spreadsheet One way to navigate in your spreadsheet is by typing the cell reference into the name box at the left of the formula bar, then press Enter. This is especially useful in a large spreadsheet.

Using the Keyboard to Move Around in Your Worksheet Press the Tab key to move forward horizontally. Press Shift+Tab to move backward horizontally. Use the Up and Down arrow keys to move vertically. Tip: You can use the same key strokes to move around in a Microsoft Word table.

To Summarize What We’ve Learned: Move around your worksheet using Tab, Shift+Tab, and the arrow keys, or by using the scrollbars; Locate specific cells in your worksheet by typing the cell reference in the Name Box on the Formula Bar; An Excel workbook is made up of one or more worksheets. To move from one worksheet to another, use the Sheet Tabs at the bottom right of your Excel window.