Excel 2010 Bible

99 CHAPTER Introducing Tables IN THIS CHAPTER Understanding how a table differs from a normal range Working with tables Using th ...

Part I: Getting Started with Excel 100 Setting up data like this in a range of cells is very straightforward. The magic happens ...

Chapter 5: Introducing Tables 101 FIGURE 5.2 An Excel table. What’s the difference between a standard range and table? l Activat ...

Part I: Getting Started with Excel 102 FIGURE 5.3 When you select a cell in a table, you can use the commands located on the Tab ...

Chapter 5: Introducing Tables 103 The range is converted to a table (using the default table style), and the Table Tools ➪ Desig ...

Part I: Getting Started with Excel 104 FIGURE 5.5 Excel offers many different table styles. FIGURE 5.6 Use this dialog box to cr ...

Chapter 5: Introducing Tables 105 Tip If you would like to make changes to an existing table style, locate it in the Ribbon and ...

Part I: Getting Started with Excel 106 Similarly, if you enter data in the row below a table, Excel extends the table vertically ...

Chapter 5: Introducing Tables 107 Or, you can use these steps to move a table to different worksheet or workbook: Press Ctrl+A ...

Part I: Getting Started with Excel 108 By default, a Total Row displays the sum of the values in a column of numbers. In many ca ...

Chapter 5: Introducing Tables 109 Cross-Reference For more information about formulas, including the use of formulas in a table ...

Part I: Getting Started with Excel 110 Sorting and filtering a table ........................................................... ...

Chapter 5: Introducing Tables 111 And within each area, sort the rows by list price. For this type of sort, first sort by the Li ...

Part I: Getting Started with Excel 112 FIGURE 5.11 Using the Sort dialog box to specify a three-column sort. Filtering a table . ...

Chapter 5: Introducing Tables 113 You can filter by multiple values in a column by using multiple check marks. For example, to f ...

...

115 CHAPTER Worksheet Formatting IN THIS CHAPTER Understanding how formatting can improve your worksheets Getting to Know the Fo ...

Part I: Getting Started with Excel 116 FIGURE 6.1 In just a few minutes, some simple formatting can greatly improve the appearan ...

Chapter 6: Worksheet Formatting 117 FIGURE 6.2 The Mini toolbar appears above the right-click shortcut menu. The Mini toolbar co ...

Part I: Getting Started with Excel 118 If you use a tool on the Mini toolbar, the shortcut menu disappears, but the toolbar rema ...