How to create a list

1. Select the range of data that you want to make into a list, or just click inside the data if you want it all.
2. On the Data menu, point to List, and then click Create List. (on Mac Office 2004, click Insert, then List)
3. If your data has column headings, make sure that the check box My list has headers is selected. Click OK. If your list does not have headers, Excel will create them for you. They'll say "Column1," "Column2," and so on.

The list is identified by a dark blue border. When you select a cell, row, or column outside a list, the list becomes inactive and is surrounded by a light blue border.

Tips

• You can also create a list by pressing CTRL+L (Option+L for Mac Office 2004) or by right-clicking and then clicking Create List on the shortcut menu.
• If you prefer to see no border at all when you click outside a list, right-click inside the list. On the shortcut menu, point to List, and then click Hide Border of Inactive Lists. To reactivate the border, repeat this process. This will hide or display the borders of all inactive lists on a worksheet. (Use the List Toolbar and toggle Visuals off/on for Mac Office 2004).

How to add or delete list rows and columns

1. Click in the list where you want to insert or delete.
2. On the List toolbar, click List, click either Insert or Delete, and then click either Row or Column.

* Or right-click a cell and click Insert or Delete on the shortcut menu and then click Row or Column.
* Or click and drag the lower-right corner of a list to add or remove rows or columns in your list.

If the columns or rows contain data, it will be included in the list. You cannot add or remove both rows and columns at the same time.

Freeze panes

Keep column names in sight as you scroll through worksheets.

To freeze names, make a selection in the worksheet, and then click Freeze Panes on the Windows menu. Do not select the names themselves.

To freeze:

• Column names - Select the first row below the names.
• Row names - Select the first column to the right of the names.
• Both column and row names - Click the cell that is both just below the column names and just to the right of the row names.

Tip: You can freeze panes anywhere, not just below the first row or to the right of the first column. For example, if you wanted the information in the first three rows to stay in sight as you scroll, you would select the fourth row and then freeze panes.

Keyboard shortcuts

Pressing Arrow keys
Moves one cell up, down, left, or right

SHIFT+Arrow key
Extends a selection cell by cell as you press the arrow key

CTRL+Arrow key
Moves to the edge of your data

F5
Opens the Go To dialog box

F2
Edits the active cell and positions the insertion point at the end of the contents of the cell

CTRL+END
Moves the insertion point to the last used cell on the worksheet

CTRL+HOME
Moves the insertion point to the beginning of the worksheet

PAGE UP
Moves one screen up

PAGE DOWN
Moves one screen down

CTRL+PAGE UP
Moves to the previous sheet

CTRL+PAGE DOWN
Moves to the next sheet

ALT+PAGE UP
Moves one screen to the left

ALT+PAGE DOWN
Moves one screen to the right

Find All

To use Find All to find all instances of the same thing entered in cells throughout a worksheet:

1. On the Edit menu, click Find. Type what you want to find in the Find what box.
2. Click Find All. All instances of what you are looking for will appear in a list in the Find and Replace dialog box.

Click a specific occurrence in the list and the insertion point goes right to the specific cell in the worksheet.

Copy and move worksheets

To copy a worksheet, do one of the following:

• Hold down CTRL while you drag the sheet along the row of sheet tabs. When you get to the location where you want to add the copied worksheet, release the mouse button and then the CTRL key.
• Right-click a worksheet tab, and then click Move or Copy on the shortcut menu. Click the sheet that you want to copy in the Before sheet list. Then select the Create a copy check box and click OK.
• On the Edit menu, click Move or Copy Sheet. Click the sheet that you want to copy in the Before sheet list. Then select the Create a copy check box and click OK.

To move a worksheet, do one of the following:

• Drag the worksheet tab of the sheet that you want to move to its new position.
• Right-click the worksheet tab that you want to move, and then click Move or copy on the shortcut menu. Click the position that you want to move the sheet to in the Before sheet list, and then click OK.
• Click the worksheet tab of the sheet that you want to move. On the Edit menu, click Move or Copy Sheet. Click the position that you want to move the sheet to in the Before sheet list, and then click OK.

Templates

A template is an Excel worksheet with content and formatting that you use as a model to create other similar worksheets. You set options and enter data in a template, and then when you base new worksheets on the template, the new worksheets receive the same settings and initially contain the same data.

How to create a Worksheet template

1. Create a workbook that contains one worksheet. On the worksheet, include the formatting, styles (style: A combination of formatting characteristics, such as font, font size, and indentation, that you name and store as a set. When you apply a style, all of the formatting instructions in that style are applied at one time.), text, and other information you want to appear on all new sheets of the same type.
2. To display a picture of the first page of a template in the Preview box of the Templates dialog box (General Templates..., New Workbook task pane), click Properties on the File menu, click the Summary tab, and then select the Save preview picture check box.
3. On the File menu, click Save As.
4. In the Save as type box, click Template.
5. In the Save in box, select the folder where you want to store the template.