[ Pobierz całość w formacie PDF ]
.From the workbook into which you want to merge styles, choose Format ª' Style 07 539671 ch05.qxd 8/28/03 9:59 AM Page 103Chapter 5 &' Worksheet Formatting103and click the Merge button.Excel displays the Merge Styles dialog box with a list ofall open workbooks.Select the workbook that contains the styles you want to mergeand click OK.Excel copies styles from the workbook that you selected into the activeworkbook.When you re merging styles, colors are based on the palette stored with the work-book in which you use the style.Therefore, if the two workbooks involved in themerge use different color palettes, the colors used in the styles may not look thesame in each workbook.TipYou may want to create a master workbook that contains all of your custom stylesso that you always know which workbook to merge styles from.Controlling styles with templatesWhen you start Excel, it loads with several default settings, including the settingsfor stylistic formatting.If you spend a lot of time changing the default elements,you should know about templates.Here s an example.You may prefer to use 12-point Arial rather than 10-point Arial asthe default font.And maybe you prefer Wrap Text to be the default setting for align-ment.Templates provide an easy way to change defaults.The trick is to create a workbook with the Normal style modified to the way thatyou want it.Then, save the workbook as a template in your XLStart folder.Afterdoing so, you can select File ª' New to display a dialog box from which you canchoose the template for the new workbook.Template files also can store othernamed styles, providing you with an excellent way to give your workbooks aconsistent look.Cross- Chapter 6 discusses templates in detail.Reference&' &' &' 07 539671 ch05.qxd 8/28/03 9:59 AM Page 104 08 539671 ch06.qxd 8/28/03 9:59 AM Page 105C H A P T E R66UnderstandingFiles and&' &' &' &'In This ChapterTemplatesCreating a newworkbookOpening an existingxcel, of course, uses files to store its workbooks.ThisworkbookEchapter discusses how Excel uses files including a spe-cial type of file called a template.Template files can be usedSaving and closingfor a variety of purposes, ranging from custom fill-in-the-workbooksblanks workbooks to a way to change Excel s defaults fornew workbooks or new worksheets.UnderstandingExcel s templatesEven if you create Excel worksheets only for your own use,you ll find templates quite useful.By making your own tem-Working with theplate files, you save a lot of time in the future when you wantdefault templatesto make use of the same settings, formulas, or even suchthings as custom number formats you ve developed.Creating customtemplates&' &' &' &'Understanding Excel FilesThis section describes the operations that you perform withworkbook files: opening, saving, closing, deleting, and so on.As you read through this section, remember that you canhave any number of workbooks open simultaneously, and thatat any given time, only one workbook is the active workbook.The workbook s name is displayed in its title bar (or in theExcel title bar if the workbook is maximized).Creating a new workbookWhen you start Excel, it automatically creates a new (empty)workbook called Book1.This workbook exists only in memoryand has not been saved to disk.By default, this workbookconsists of three worksheets named Sheet1, Sheet2, andSheet3.If you re starting a new project from scratch, you canuse this blank workbook. 08 539671 ch06.qxd 8/28/03 9:59 AM Page 106Part I &' Getting Started with Excel106Excel provides several ways to create a new workbook:&' Use the File ª' New command (which opens the New Workbook task pane)and click one of the selections in the New Workbook task pane (as shown inFigure 6-1).&' Click the New Workbook button on the Standard toolbar.(This button has animage of a sheet of paper.)&' Press the Ctrl+N shortcut key combination.TipPressing Ctrl+N or clicking the New button on the Standard toolbar bypasses theNew Workbook Task Pane and creates a new default workbook immediately.If youwant to create a new workbook based on a template, you can use one of the tem-plate options on the New Workbook task pane.Figure 6-1: The New Workbook task pane enablesyou to create a new workbook.Templates can come from several sources: Microsoft s Web site, your computer, oryour own Web site (if you have one).If you select On My Computer from the NewWorkbook task pane, Excel displays the Templates dialog box.This is a tabbed dia-log box that enables you to choose a template for the new workbook.If you don thave any custom templates defined, the General tab displays only one option:Workbook.Clicking this gives you a plain workbook.Templates that are includedwith Excel are listed in the Spreadsheet Solutions tab.If you choose one of thesetemplates, your new workbook is based on the selected template file. 08 539671 ch06.qxd 8/28/03 9:59 AM Page 107Chapter 6 &' Understanding Files and Templates107Starting Excel Without an Empty WorkbookIf you prefer to avoid the empty workbook displayed when Excel starts up, you can do so byediting the command line that is used to start Excel.For example, if you normally launchExcel by clicking a shortcut on your desktop, you can modify the shortcut as follows:1 [ Pobierz caÅ‚ość w formacie PDF ]