Excel 97/2000 Introduction II Windows 95/98 Working with Workbooks Excel 2000 is the version following Excel97.  It has been expanded to offer more options while attempting to create a more intuitive environment.  It starts you off with a workbook file.  This file stores up to 255 sheets. These sheets can be spreadsheets (which are the same as worksheets), charts, macros, or pivot table sheets.  By default, when you open a new workbook, there are three sheets available for use.  If you wish to change the default number of sheets in your workbooks, go to the Tools menu and select Options.  From the Options tab box, choose General and look for the Sheets in New Workbook field to change the number of sheets.  If you wish to see a list of the new features offered in Excel 2000, go to the Help menu and select Microsoft Excel Help.  In the right hand window click on the underlined phrase, Finding out what’s new in Excel 2000. Workbook Navigation To move between the sheets in a workbook, use the sheet tabs located on the left side of the horizontal scrollbar at the bottom of the page.  These tabs display the name of each sheet in the workbook.  The sheet name, shown in bold on a white background, is the currently active sheet.  You may use the scroll buttons at the left of the sheet tabs to scroll quickly among the sheets in your workbook. Sheet Names In a new workbook, sheets are given the default names of "Sheet1", "Sheet2", etc.  To change the name of a sheet, double-click on the tab and type in a new name.  Sheet names must adhere to the following rules: · no more than 31 characters in length (you can use spaces!). · must be unique within the workbook. · must not use the following special characters: \, /, *, ?, :, [ or ]. The Shortcut Menu Clicking once with the right mouse button on any sheet tab will bring up a shortcut menu which displays all options for working with your sheet: insert, delete, copy, move, rename, select all sheets, and view code. Inserting and Deleting Sheets To insert a sheet into a workbook, click on the sheet tab to the right of your desired insertion point. Using the right mouse button, bring up the tab shortcut menu and choose Insert.  Select the type of sheet you want to insert.  To delete a sheet from a workbook, click on its tab and select Delete from the shortcut menu. Moving and Copying Sheets It's easy to move sheets from one location to another within a workbook by dragging and dropping the sheet's tab at a new location.  Likewise, you can make a copy of a sheet in the current workbook by selecting the sheet to be copied, holding down the Ctrl key and dragging the sheet to the new location.  You can also move or copy a sheet to another workbook by dragging the sheet tab to the other workbook.  However, you must first have the other workbook open and tiled in the same window.  The Move or Copy Sheet... dialog box under the Edit menu allows you to do the same thing.