[ Pobierz całość w formacie PDF ]
.Closing windowsIf you have multiple windows open, you may want to close those windows that youno longer need.To close a window, select File ª' Close or simply click the Close but-ton (the X icon) on the worksheet window s title bar.If the workbook window ismaximized, its title bar is not visible, so its Close button appears directly belowExcel s Close button.When you close a workbook window, Excel checks whether you have made anychanges since the last time you saved the file.If not, the window closes without aprompt from Excel.If you ve made any changes, Excel prompts you to save the filebefore it closes the window.Making a worksheet the active sheetAt any given time, one workbook is the active workbook, and one sheet is the activesheet in the active workbook.To activate a different sheet, just click its sheet tab,located at the bottom of the workbook window.You also can use the followingshortcut keys to activate a different sheet: 05 539671 ch03.qxd 8/28/03 9:58 AM Page 47Chapter 3 &' Essential Worksheet Operations47&' Ctrl+PgUp: Activates the previous sheet, if one exists&' Ctrl+PgDn: Activates the next sheet, if one existsIf your workbook has many sheets, all of its tabs may not be visible.You can usethe tab-scrolling buttons (see Figure 3-3) to scroll the sheet tabs.The sheet tabsshare space with the worksheet s horizontal scroll bar.You also can drag the tabsplit box to display more or fewer tabs.Dragging the tab split box simultaneouslychanges the number of tabs and the size of the horizontal scroll bar.Figure 3-3: Use the tab controls toactivate a different worksheet or tosee additional worksheet tabs.Drag the tab split box to change the number of tabs.TipWhen you right-click any of the tab-scrolling buttons to the left of the worksheettabs, Excel displays a list of all sheets in the workbook.You can quickly activate asheet by selecting it from the list.Adding a new worksheet to your workbookWorksheets can be an excellent organizational tool.Instead of placing everythingon a single worksheet, you can use additional worksheets in a workbook to sepa-rate various workbook elements logically.For example, if you have several productswhose sales you track individually, you might want to assign each product to itsown worksheet and then use another worksheet to consolidate your results.The following are three ways to add a new worksheet to a workbook:&' Select the Insert ª' Worksheet command.&' Press Shift+F11.&' Right-click a sheet tab, choose the Insert command from the shortcut menu,select Worksheet from the Insert dialog box, and then click OK.When you add a new worksheet to the workbook, Excel inserts the new worksheetbefore the active worksheet, and the new worksheet becomes the active worksheet.TipTo insert more than one worksheet at a time, hold down the Shift key and click arange of worksheet tabs.When you issue the command to insert a worksheet,Excel will add as many worksheets as the number of worksheet tabs you selectedbefore issuing the command. 05 539671 ch03.qxd 8/28/03 9:59 AM Page 48Part I &' Getting Started with Excel48Deleting a worksheet you no longer needIf you no longer need a worksheet, or if you want to get rid of an empty worksheetin a workbook, you can delete it in either of two ways:&' Select the Edit ª' Delete Sheet command.&' Right-click the sheet tab and choose the Delete command from the shortcutmenu.If the worksheet contains any data, Excel asks you to confirm that you want todelete the sheet.If you have never used the worksheet, Excel deletes it immediatelywithout asking for confirmation.TipYou can delete multiple sheets with a single command by selecting the sheets thatyou want to delete.To select multiple sheets, press Ctrl while you click the sheettabs that you want to delete.To select a group of contiguous sheets, click the firstsheet tab, press Shift, and then click the last sheet tab.Then use either method todelete the selected sheets.CautionWhen you delete a worksheet, it s gone for good.This is one of the few operationsin Excel that can t be undone.Changing the name of a worksheetThe default names Excel uses for worksheets Sheet1, Sheet2, and so on aren tvery descriptive.If you don t change the worksheet names, it can be a bit hard toremember where to find things in multiple-sheet workbooks.That s why providingmore-meaningful names for your worksheets is often a good idea.Changing the Number of Sheets in Your WorkbooksBy default, Excel automatically creates three worksheets in each new workbook.You canchange this default behavior.For example, I prefer to start each new workbook with a sin-gle worksheet.After all, it s easy enough to add new sheets if and when they are needed.To change the default number of worksheets:1.Select Tools ª' Options.2.In the Options dialog box, click the General tab.3.Change the value for the Sheets in New Workbook Setting and click OK.Making this change will affect all new workbooks but will have no effect on existingworkbooks. 05 539671 ch03.qxd 8/28/03 9:59 AM Page 49Chapter 3 &' Essential Worksheet Operations49To change a sheet s name, use any of the following methods to begin:&' Choose Format ª' Sheet ª' Rename.&' Double-click the sheet tab.&' Right-click the sheet tab and choose the Rename command from the shortcutmenu [ Pobierz caÅ‚ość w formacie PDF ]