Excel 2010 Bible

Chapter 9: Printing Your Work 179 Note The print area does not have to be a single range. You make a multiple selection before y ...

Part I: Getting Started with Excel 180 Note Even though Excel displays a variety of paper sizes, your printer may not be capable ...

Chapter 9: Printing Your Work 181 FIGURE 9.4 The Margins tab of the Page Setup dialog box. Understanding page breaks ........... ...

Part I: Getting Started with Excel 182 To insert a vertical page-break line, move the cell pointer to the cell that will begin t ...

Chapter 9: Printing Your Work 183 FIGURE 9.5 Use the Sheet tab of the Page Setup dialog box to specify rows or columns that will ...

Part I: Getting Started with Excel 184 A watermark is an image (or text) that appears on each printed page. A watermark can be a ...

Chapter 9: Printing Your Work 185 Printing row and column headers .............................................................. ...

Part I: Getting Started with Excel 186 When you activate the header or footer section in Page Layout view, the Ribbon displays a ...

Chapter 9: Printing Your Work 187 Button Code Function File Path &[Path]&[File] Displays the workbook’s complete path an ...

Part I: Getting Started with Excel 188 Copying Page Setup Settings across Sheets ............................................... ...

Chapter 9: Printing Your Work 189 If you find that you must regularly hide data before you print certain reports, consider using ...

Part I: Getting Started with Excel 190 Creating Custom Views of Your Worksheet ................................................. ...

Chapter 9: Printing Your Work 191 FIGURE 9.8 Use the Add View dialog box to create a named view. Then, when you’re ready to prin ...

...

F ormulas and worksheet functions are essential to manipulating data and obtaining useful information from your Excel workbooks. ...

14_474877-pp02.indd 19414_474877-pp02.indd 194 3/29/10 11:41 PM3/29/10 11:41 PM ...

195 CHAPTER Introducing Formulas and Functions IN THIS CHAPTER Understanding Formula Basics .................................... ...

Part II: Working with Formulas and Functions 196 Note When you’re working with a table, a feature introduced in Excel 2007 enabl ...

Chapter 10: Introducing Formulas and Functions 197 Operator Name = Logical comparison (equal to) Logical comparison (greater th ...

Part II: Working with Formulas and Functions 198 TABLE 10.2 Operator Precedence in Excel Formulas Symbol Operator Precedence ^ E ...