Excel Worksheet Navigation

Study Notes

The Name Box displays the address of the current selection or active cell.
The Formula Bar displays information entered or being entered as you type in the current or active cell, and also allows editing of cell contents.

A cell is the most basic part of an Excel document, holding a piece of data, and is an intersection of a column and row.

Navigation buttons allow movement to another worksheet in an Excel workbook.
Sheet tabs separate a workbook into specific worksheets, with a default of three worksheets (Sheet1, Sheet2, and Sheet3).
A workbook must contain at least one worksheet.

To move the cell pointer, click on a cell with the mouse, or use keyboard arrow keys (up, down, left, or right).
Keyboard shortcuts for movement:
- One cell up: up arrow key
- One cell down: down arrow key or ENTER
- One cell left: left arrow key
- One cell right: right arrow key or TAB
- Top of the worksheet (cell A1): CTRL+HOME
- End of the worksheet (last cell containing data): CTRL+END
- End of the row: CTRL+right arrow key
- End of the column: CTRL+down arrow key
- Any cell: CTRL + G to open the Go To dialog box

The vertical scroll bar is used to move up or down the spreadsheet.
The horizontal scroll bar is used to move left or right across the spreadsheet.
PageUp and PageDown keys move the cursor up or down one screen at a time.
Other scrolling keys: Home (moves to the first column on the current row) and Ctrl+Home (moves to the top left corner of the spreadsheet or cell A1).

To move between worksheets, click on the sheet tab (Sheet1, Sheet2, or Sheet3) that you want to display.
To rename a worksheet, use one of the following methods:
- In the CELLS group of the Home tab, choose FORMAT, and select RENAME SHEET
- Double-click the sheet tab
- Right-click the tab for the worksheet you want to rename and choose Rename from the shortcut menu

To create a new blank workbook:
- Click the File tab
- Select New
- Select Blank workbook under Available Templates
- Click Create
To open an existing workbook:
- Click the File tab
- Select Open
- Select your desired workbook, then click Open
To save a worksheet, use one of the following methods:
- Click the SAVE button in the Quick Access toolbar
- Press F12 to open the Save As dialog box
- Click FILE tab and from the menu, select SAVE or SAVE AS command

Entering text in a cell:
- Select the cell in which data has to be entered
- Type the text
- Press ENTER key to finish your text entry
- The text will be displayed in the active cell as well as in the Formula bar
Data types that can be entered in a cell:
- Numbers (whole numbers, decimals, and scientific notation)
- Text