Microsoft Office Professional 2010 Step by Step eBook

Move the image to the upper-left corner of the worksheet, click and hold the handle at the lower-right corner of the image, and ...

344 Chapter 11 Change Workbook Appearance You can use an image file to create a worksheet background. On the Page Layout tab, i ...

Key Points. ● If you don’t like the default font in which Excel displays your data, you can change it. ● You can use cell format ...

Chapter at a Glance Limit data that appears on your screen, page 348 Manipulate worksheet data, page 354 Define valid sets of va ...

347 12 Focus on Specific Data by Using Filters In this chapter, you will learn how to ✔ Limit data that appears on your screen. ...

348 Chapter 12 Focus on Specific Data by Using Filters Limiting Data That Appears on Your Screen. Excel spreadsheets can hold as ...

Important When you turn on filtering, Excel treats the cells in the active cell’s column as a range. To ensure that the filterin ...

350 Chapter 12 Focus on Specific Data by Using Filters You can enter partial or entire words in the Text Filters box. When you p ...

On the ByRoute worksheet, click any cell in the cell range B2:F27. On the Home tab, in the Editing group, click Sort & Filt ...

352 Chapter 12 Focus on Specific Data by Using Filters Excel displays only those exceptions that occurred in the Midwest distrib ...

Excel displays the table rows that contain the five highest values in the column. Click the Exceptions column filter arrow, and ...

354 Chapter 12 Focus on Specific Data by Using Filters Manipulating Worksheet Data Excel offers a wide range of tools you can us ...

was introduced, you had to create formulas that added, subtracted, multiplied, and divided the results of the RAND function, whi ...

356 Chapter 12 Focus on Specific Data by Using Filters any hidden rows. The formula =SUBTOTAL(109, C3:C26, E3:E26, G3:G26) would ...

visible in the worksheet. Operations 1-11 summarize all cells in a range, regardless of whether the range contains any manually ...

358 Chapter 12 Focus on Specific Data by Using Filters Number Function Description 15 SMALL Returns the k-th smallest value in a ...

You can filter the original list or create a filtered copy of the list. In the List Range field, type the reference of the cell ...

360 Chapter 12 Focus on Specific Data by Using Filters Tip Remember that you must include cell E2, the header cell, in the List ...

You can paste the results of formulas rather than the formulas themselves. CLEAN UP Save the ForFollowUp workbook, and then clos ...

362 Chapter 12 Focus on Specific Data by Using Filters Data validation rules are intended to ensure that worksheet users enter t ...