Jan 18, 2007 (Th)

• Reviewed HW problems
• Formatting and using multiple worksheets

DEFINTIONs:

Workbook

the entire Excel file

Worksheet

one "tab" in the Excel file

Skills

1. Creating, deleting, renaming sheets: right click on the sheet and choose what to do
2. Moving Sheets: just drag the tab for the sheet
3. selecting multiple sheets
• To select several contiguous sheet (i.e. a few sheets one after the other): (1) click first sheet (2) hold down SHIFT and at the same time click on the last sheet.
• To select several non-contiguous sheets: hold down CTRL and at the same time click on each sheet that you want to select
• To UNSELECT multiple sheets: click on a tab that is not currently selected (if all sheets are selected, click on any one of them)

Q: Why would you want to select multiple Sheets?

A: When you work with mulitple selected sheets:

1. Any FORMATTING changes that you apply to one of the selected sheets is automatically applied to all the selected sheets
2. Anything you type (e.g. data or forumulas) in one of the selected sheets is automatically placed into all the selected sheets
• Dragging cells to copy their contents

click and drag on the "dot" in lower right hand corner of the selected cells (you can select one or more cells for this)

This will copy the cells

If Excel recognizes a pattern the orignally selected cells it will fill in the pattern in the new cells. EXAMPLES:

1. selected cells = 1,2 --> excel fills in 3,4,5, etc
2. selected cells = Mon,Tue --> excel fills in Wed,Thu,Fri,Sat,Sun,Mon,Tue, etc
3. selected cells = 3,6,9 --> excel fills in 12,15,18,21, etc
4. selected cells contain a formula with cell references --> Excel will "modify" the cell references so that they "make sense" in the new location (more about this later)
• Drawing Borders around cells

Click on the "Format" menu, then on the "Cells" menu. In the dialog box that comes up, click on the "Border" tab. (this will be abbreviated in my notes as "Format | Cells | Border")

• Entering cell references in Formulas with the Mouse
1. Type an = sign to start the formula
2. Click to get a cell reference or range
3. Click somewhere else to change the reference
4. Type the next part of your formula (e.g. plus sign, asterisk, comma, parentheses, etc) to move to next reference
5. Click with mouse to enter the next reference
6. When you are done either (1) press enter or (2) click on the "check" button in the upper left corner of the screen.
• ESC key

If you are ever stuck in excel - try pressing the ESC key