Sheets in workbook

PAGE DOWN w Select next sheet in workbook Select next sheet in workbook... 

Select previous sheet in workbook CONTROL+PAGE UP CONTROL+PAGE UP... 

If you choose Options... from the Tools menu and choose the General tab, you can change several default settings that will apply to all future workbooks, such as the number of sheets in a new workbook. You can also switch from using Al-style references in formulas to RlCl-style references the labels in the column header row of each worksheet change from A, B, C,... to 1, 2,3,.... Formulas using RlCl-style references will not be discussed in this book. 

Excel Tip. To display a shortcut menu that lists all sheets in the workbook, right-click on any of the tab scroll buttons (Excel for Windows) or hold down the CONTROL key and click on any of the tab scroll buttons (Excel for the Macintosh). You can then select the desired sheet. 

You can create custom number formats. First, choose the Custom category from the list of numbers formats. This will display the list of (so far) built-in number formats. To add a new, user-defined number format (it wiU be added at the bottom of the list), type the format in the Type box. For example, if you want to display numbers to four decimal places, type 0.0000 in the Type box. The new format will be stored in the list of formats so that you can apply it to other cells the format will be available in all sheets in the workbook. 

There are two ways to create a chart either as a separate chart sheet in a workbook, or as a chart embedded in a worksheet, so that you can see both the data and the chart at the same time. An embedded chart is useful if you want to see how a curve changes as you change its parameters. As you change the values in worksheet cells, the chart will update automatically. 

Links between worksheets are established by means of external references. An external reference is simply a reference that includes the filename of the source worksheet, separated from the reference or name by an exclamation point, e.g., =SheetName CellReference if the link is between sheets in the same workbook or [WorkbookName]SheetName CellReference if the link is between sheets in different workbooks. 

When you assign a name to a cell or range in a workbook, the name is a global or workbook-level name. The name can be used in all sheets in the workbook. 

VBA macros are located on module sheets. In Excel 5/95, module sheets were sheets in a workbook, just like worksheets and chart sheets you could click on a sheet tab and view the VBA code. But beginning with Excel 97, the VBA programming environment became much more sophisticated. It is more professional and has more features, but it s also much more confusing for the beginner. 

To access the Visual Basic Editor, choose Macro from the Tools menu and then Visual Basic Editor from the submenu. The Visual Basic Editor screen contains two important windows the Code window and the Project window. Procedures are viewed or typed in the Code window, which corresponds to a module sheet in Excel 95. Use the Project window to select a particular code module from all the available modules in open workbooks. These are displayed in the Project window, which is usually located on the left side of the screen. If the Project window is not visible, choose Project Explorer from the... 

In the Project Explorer window you will see a hierarchy "tree" with a node for each open workbook. In the example illustrated in Figure 13-3, a new workbook. Workbooks, has been opened. The node for Workbooks has a node (a folder icon) labeled Microsoft Excel Objects click on the folder icon to display the nodes it contains — an icon for each sheet in the workbook and an additional one labeled ThisWorkbook. If you double-click on any one of these nodes you will display the code sheet for it, but these code sheets are for a special type of procedure called an automatic procedure (see Chapter 18). 

Step 3 There are several other options choose residuals, residual plots, and line fit plots. These are all useful for evaluating the results. You can place the results on another sheet in the same Workbook or on the same sheet by specifying a location. Table E.4 shows part of the output. The best fit is for... 

Step 1 Place the data on a new sheet in the Workbook, columns A, B, and C from Table E.3, as reproduced in Table E.7. 

---