Category Archives: Formatting

Stop Pivot Table Column Widths From Changing

It’s a little thing, but it can be frustrating if your pivot table column widths keep changing. In the screen shot below, I’ve made column B narrow, so the pivot table takes up less room across the worksheet. But, when … Continue reading

Posted in Formatting | Leave a comment

Change Pivot Table Data Headings and Blanks

When you add fields to the value area in a pivot table, custom names are automatically created, such as Sum of Quantity or Count of Customer. Excel won’t let you remove the "Sum of" in the label, and just leave … Continue reading

Posted in Formatting | Leave a comment

Format Pivot Table Labels Based on Date Range

In a pivot table that contains a long list of dates, you can use conditional formatting to highlight a specific date range. In this example, the pivot table contains forecast data for 2.5 years, with dates in the OrderDate field. … Continue reading

Posted in Formatting | 1 Comment

Arrange Pivot Table Data Vertically

In Excel 2003, and earlier versions, when you added multiple data fields to a pivot table, they were automatically arranged vertically. The data headings showed up in the Row area, stacked one on top of the other. If you wanted … Continue reading

Posted in Formatting, Layout | 1 Comment

Repeat Pivot Table Labels in Excel 2010

When you create a pivot table in Excel 2010 or Excel 2007, the row labels are in a compact layout – all the headings are listed in column A. You can change the Report Layout setting, to either Outline form … Continue reading

Posted in Formatting | Leave a comment

Copy Pivot Table Values and Formats

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 … Continue reading

Posted in Formatting | Leave a comment

Problems With Pivot Table Comments

In some pivot tables, you might want to add comments to a few cells, to help the users understand what the results mean, or to explain the different pivot fields. However, if you add comments to a pivot table, you’ll … Continue reading

Posted in Formatting | 9 Comments

Create a Custom PivotTable Style

There are many built-in PivotTable styles in Excel 2007, but you might not see one that has the exact formatting you need. For example, you might like the heading colors in the Pivot Style Medium 9, but you’d like a … Continue reading

Posted in Formatting | Tagged , | 15 Comments

Remove a Pivot Table Style in Excel 2007

When you create a pivot table in Excel 2007, a default PivotTable style is automatically applied to a pivot table. For example, in the screen shot below, the pivot table uses the Pivot Style Light 16. Remove the Pivot Table … Continue reading

Posted in Formatting | Leave a comment

Keep Formatting in Excel 2007 Pivot Table

Even though a pivot table is automatically formatted when you create it, you can add your own formatting later. For example, in the pivot table shown below, I’ve added colour to the subtotal rows, and made column B narrow. However, … Continue reading

Posted in Formatting | 21 Comments