How To Format A Pivot Table In Excel: Simple Steps

Enhance your Excel skills by discovering how to format a pivot table in Excel. In this article, we will teach you how to do it with just a few simple steps.

Formatting a pivot table is an easy thing to do. It makes our data or pivot table look presentable and pleasing to the eyes. If you are not satisfied with the look of your pivot table, you can change its style and even its layout.

In doing so, you need not worry, as with just a few clicks, we can format a pivot table without a hassle, and that’s what you’ll be able to learn here. But before that, let’s first take a quick look at a pivot table. Learn its meaning and what its uses are.

What is a Pivot Table?

pivot table is an essential Excel feature that helps users quickly organize and summarize complex data. This feature allows users to group their data by columns, sort it by values, and calculate statistics.

In addition, pivot tables are handy when you have a large quantity of data. Before proceeding to our tutorial, first learn how to create a pivot table.

How to Create a Pivot Table

If you want to create a pivot table, you should have your data set. Once you have your data, you can start creating pivot tables. Here’s a tutorial on how to make one:

→ Click anywhere on your data, then the Insert tab.
In the Tables group, click PivotTable, then select “from table/range.”

Click Insert, Tables, PivotTable, then From Table or Range

→ After clicking “from table or range,” a PivotTable from table or range dialog box will appear.

Select “new worksheet” if you want to place your pivot table on a new worksheet. However, select “existing worksheet” if you want to place your pivot table on the same worksheet as your data, then select a cell where you want to place it and click OK.

Select existing worksheet, cell, then OK

Formatting a Pivot Table in Excel

The following are simple steps to format a pivot table in Excel.

  1. Click anywhere in the pivot table.

  2. Click the design tab under PivotTable Tools.

    After clicking the design tab, you’ll see three groups. The Layout group, the PivotTable Style Options group, and the PivotTable Styles group.

    PivotTable Design

Tip: You can also right-click the pivot table, then select format cells. After that, a format cells dialog box will appear. Then, you'll see number, alignment, font, border, fill, and protection tabs (see image below).
Format Cells Dialog Box

Change the Pivot Table Styles

To change the style of a pivot table, click the More button in the PivotTable Styles group.

More button

After clicking the “more” button, you’ll see the PivotTable styles gallery. There, you can choose the style that you want for your pivot table.

  • You can scroll down the scroll bar to see more designs.
  • You can also click the new PivotTable Style to create a new PivotTable Style.
  • And you can also click Clear to clear the table style.
PivotTable Styles Gallery

PivotTable Style Options

In the pivot table style options, you’ll see:

PivotTable Styles Options
  1. Row Headers, which can show special formatting for the first row of the table.
  2. Column Headers, which can show special formatting for the first column of the table.
  3. Banded Rows, which format even rows differently from odd rows.
  4. Banded Columns, which format even columns differently from odd columns.

You can check or uncheck any of these four based on your preferred format.

Format the Pivot Table Layout

In the Layout group, you can format the following:

  1. Subtotals. Here, you can show or hide subtotals of your data.
Subtotals - How To Format A Pivot Table In Excel: Simple Steps
  1. Grand TotalsHere, you can show or hide the grand totals of your data.
Grand Totals - How To Format A Pivot Table In Excel: Simple Steps
  1. Report Layout. Here, you can adjust the report layout.
Report Layout - How To Format A Pivot Table In Excel: Simple Steps
  1. Blank RowsHere, you can insert and remove blank lines after each item.
Blank Rows - How To Format A Pivot Table In Excel: Simple Steps


In conclusion, formatting a pivot table in Excel is easy and quick. Learning how to do it is also an easy thing to do. Just follow the simple steps in the tutorial above.

I believe that we have accomplished this tutorial. I hope you’ve learned something from this. Do not forget to share this with your friends. If you have any questions or suggestions, please leave a comment below, and for more educational content, visit our website.

Thank you for reading!

Leave a Comment