Double-clicking on a number cell in a pivot table creates a new sheet in the workbook, showing the records included in that number. Sometimes the list doesn’t look the way you’d like it to, and the numbers aren’t formatted the way they are in the source data. For example, the source data might have sales [...]

If you create a pivot table in Excel 2007 and later versions, formatting is automatically applied by the PivotTable Styles feature. This feature makes it quick and easy to format your pivot tables, and helps you stay consistent with the Theme settings in your Excel file. Problems with Format Copying Occasionally, you might want to [...]

An Excel Table is a new feature in Excel 2007, similar to the List feature in Excel 2003. An Excel Table makes it easy for you to sort, filter, and review your data, whether it’s a few rows and columns, or thousands. You can also use an Excel Table as the source for a Pivot [...]