ACS 101 July Block II 2004 Excel Notes
Workbooks
Multiple worksheets:
Excel allows you to have several worksheets in a single file, which is referred to as a workbook . A workbook may also contain other types of sheet and Visual Basic macros for automating tasks. Whenever you save the file, all sheets in the workbook will be saved together.
Similarly, loading a file loads into memory all the sheets in a workbook. The sheets are shown in the sheet tabs at the bottom of the window. The sheets in a workbook can be of two different types:
● Worksheets, for the entry of data and formulae and the calculation of results.
Chart sheets, for display of graphs and charts. Each sheet in the workbook has a tab at the bottom of the window. Initially the sheets are called Sheet1, Sheet2 etc. but these sheets can be changed to something more meaningful. By default, Excel gives you three sheets for each workbook but this number can be increased when necessary. The View Tab for Tools | Options changes the way in which worksheets are displayed. Some of these features relate to the current worksheet only; others affect the whole workbook. Practical on renaming a sheet in a workbook 1. Doubleclick on the sheet tab at the bottom of the window
2. Enter a new name in the sheet tab; the name can be up to 31 characters long, using any characters, including spaces.
3. Click on OK. The new name is shown in the sheet tab, which expands to show the full name. You can also rename sheets with Format | Sheet | Rename Starting a new sheet:
To start a new worksheet in the workbook, simply click on any of the sheet tabs at the bottom of the window; for example, sheet 2. You will be presented with a blank sheet, in which a new set of data, formulae and titles can be entered. If you want to change the sheet name, double click on sheet name (sheet2) and change the sheet name. This sheet need not to have any connection with any other sheet in the workbook, other than the fact that all sheets are saved and loaded together. You can simply switch from one sheet to another simply by clicking on the sheet tabs at the bottom of the window. When a tab is clicked, the corresponding sheet is displayed in the window and the sheet name is highlighted on the tab. When you have a number of sheets, you will not be able to see all the tabs. The tabs can be
scrolled to the left or right with the small tab buttons. Clicking on these buttons only moves the tabs; it does not select a different sheet. The bar along the bottom is shared by the sheet tabs and the horizontal scroll bars. You can change the amount used to each by dragging the divider to the left or right. Multiple windows: You can display more than one worksheet from the file at a time by opening new windows onto the workbook. Select the Window | New
Window command and the effect is that a second window is opened. showing the same sheet. The window can be resized or moved to show data in the most convenient form, using the usual Windows actions. You may also need to change the size of the windows with the View | Zoom options. These windows can be used independently. They show two different parts of the same worksheet or two different sheets from the workbook. You can enter data and formulae into either sheet. When you save the workbook, any changes made in either window are saved. When you close the workbook (with File | Exit or by clicking on Close in the control menu) all subsidiary windows are closed. If any data has not been saved, you are given the opportunity to do so. Worksheet groups: Sometimes you will want to work with more than one sheet at a time. For instance, you may want to put the same title in a series of sheets, or the row and column headings may be the same across all sheets. A group of sheets can be selected: either a group of consecutive sheets or a selection of nonadjacent sheets. Any
