Excel 2010 Bible

Chapter 7: Understanding Excel Files 159 Recognizing the Excel 2010 file formats ............................................... ...

...

161 CHAPTER Using and Creating Templates IN THIS CHAPTER Understanding Excel templates Working with the default templates Creati ...

Part I: Getting Started with Excel 162 FIGURE 8.1 The New page in Backstage View displays template categories. Note Microsoft Of ...

Chapter 8: Using and Creating Templates 163 Note It’s important to understand that you’re not working with the template file. Ra ...

Part I: Getting Started with Excel 164 FIGURE 8.3 The workbook, after customizing it and entering some information. Modifying a ...

Chapter 8: Using and Creating Templates 165 When you open a XLST (or *.XLT) template file, you are opening the actual file — you ...

Part I: Getting Started with Excel 166 Excel supports three types of templates, which I discuss in the following sections: l The ...

Chapter 8: Using and Creating Templates 167 Caution Excel will offer a name, such as Book1.xlt. You must change this name to boo ...

Part I: Getting Started with Excel 168 When your workbook is set up to your liking, choose File ➪ Save As. In the Save As dialo ...

Chapter 8: Using and Creating Templates 169 Note You could, of course, just use the previous month’s workbook and save it with a ...

Part I: Getting Started with Excel 170 Saving your custom templates ............................................................ ...

171 CHAPTER Printing Your Work IN THIS CHAPTER One-click printing Changing your worksheet view Adjusting your print settings for ...

Part I: Getting Started with Excel 172 of the default print settings (by using the Page Layout tab), Excel uses the new settings ...

Chapter 9: Printing Your Work 173 Just click one of the icons to change the view. You can also use the Zoom slider to change the ...

Part I: Getting Started with Excel 174 Tip If you’d prefer to not see the page break display in Normal view, choose FIle ➪ Optio ...

Chapter 9: Printing Your Work 175 Tip If you move the mouse to the corner of a page while in Page Layout view, you can click to ...

Part I: Getting Started with Excel 176 l (^) Displays the current print range with a white background; nonprinting data appears ...

Chapter 9: Printing Your Work 177 Adjusting Common Page Setup Settings ......................................................... ...

Part I: Getting Started with Excel 178 TABLE 9.1 (continued) Setting Print Settings Screen Page Layout Tab of Ribbon Page Setup ...