Microsoft Excel- Use Autoformat With Pivot Tables_5522

Microsoft Excel: Use Autoformat With Pivot Tables

See all Microsoft Excel tips

Strategy:

Use one of the 22 built-in AutoFormats for pivot tables. Even if you don’t normally use AutoFormat in regular Excel, you should consider it in pivot tables.

1) Use the Format Report button on the PivotTable toolbar, as shown in Fig. 944.

The AutoFormat dialog box initially shows six different report layouts. The examples show the formatting cheap on a report with four fields in the Column area. As shown in Fig. 945 dell vostro 1000 battery, in Report 1, they are showing you that the replacement innermost level (Zone) would have a normal black font on white. The next level (Area) would have a black font on a gray shop background. The outermost level (Qtr) would have a bold font.

2) As shown in Fig. 946, use the scroll bar to see cheap the formats for Report 7 through Report 10 and Tables 1 through Table 2.

Fig. 947 shows Table 3 through Table charger 8.

The zxcsky09529 last few options are Table 9, Table 10, PivotTable Classic, and None, as shown in Fig. 948.

3) gateway Choose one of the formats and select OK.

Result:

You can quickly apply a new look to the data. Fig. 949 new shows Report 6.

If you don’t like one look, choose the Format Report icon again and select a different look. store Fig. 950 shows Table 7.

Even with these formats, you can still pivot the report as usual. Here, as shown in Fig. compaq 951 Dell Inspiron 9400 Battery, the Product field moves up to the Column area Dell Vostro 2510 battery, Region is removed, and Customer is added to the Row discount area.

Summary:

For years, I used pivot tables because of their ability to quickly produce summary reports. In recent acer aspire versions of Excel Ibm Thinkpad X60 Battery, Microsoft has improved the pivot table by offering great looking ways to format the summary zxcsky09520 reports.

Commands Discussed:

PivotTable – Format Report

 

See all Microsoft Excel ti