Pinterest Pixel

Select & Format Fields in Excel Pivot Tables

When it comes to select & format fields in your Pivot Table, you can do it the... read more

Download Excel Workbook
Bryan
Posted on

Overview

Select & Format Fields in Excel Pivot Tables | MyExcelOnline Select & Format Fields in Excel Pivot Tables | MyExcelOnline

When it comes to select & format fields in your Pivot Table, you can do it the manual way, or the easy way. Thankfully you can apply formatting to a specific section or the entire Pivot Table by following the steps below.

I will show you different ways on how to utilize this!

 

Exercise Workbook:

Download excel workbookSelect-format.xlsx


Here is our current Pivot Table:

Select & Format Fields in Excel Pivot Tables

 

Enable Selection in Pivot Table

STEP 1: To enable this, go to PivotTable Analyze > Actions > Select > Enable Selection

Select & Format Fields in Excel Pivot Tables

STEP 2: Let us try it out! Select the Bottles Product from the left-hand side to highlight it.

Select & Format Fields in Excel Pivot Tables

Make any formatting change and it will apply to the entire Bottles Product. So this means we have targeted a specific product.

Select & Format Fields in Excel Pivot Tables

STEP 3: What if we want to apply a formatting change to all Product Labels in one click? Click on the top portion of Bottles.

See also  A PivotTable report cannot overlap another PivotTable report - Solution

Select & Format Fields in Excel Pivot Tables

You will see all of the Product Labels got highlighted. Make any formatting change.

Select & Format Fields in Excel Pivot Tables

STEP 4: Let us now try on a specific quarter. Select the left-hand side of Q1 to select it.

Select & Format Fields in Excel Pivot Tables

Make any formatting change. And all Q1 values will immediately have this formatting change.

Select & Format Fields in Excel Pivot Tables

STEP 5: You can do the same for a specific column. Click the 2014 column.

Select & Format Fields in Excel Pivot Tables

Make the formatting change, and see the effects happen instantaneously!

Select & Format Fields in Excel Pivot Tables

Once you have enabled selection in Pivot Table, you can easily apply formatting to any section.

 

Select Entire Pivot Table

You can also use selection arrows to select the entire Pivot Table by following the steps below:

STEP 1: Move the cursor to the top-left cell of the Pivot Table

Select & Format Fields in Excel Pivot Tables

STEP 2: Once the cursor changes to an arrow, click on the cell.

The entire Pivot Table will be selected.

Select & Format Fields in Excel Pivot Tables

 

Want an easier way than this? Luckily, Excel has that too!

Go to PivotTable Analyze > Actions > Select > Entire PivotTable

Select & Format Fields in Excel Pivot Tables

The entire Pivot Table will be selected.

See also  How to Alphabetize in Excel - 3 Useful Methods

Select & Format Fields in Excel Pivot Tables

 

Click here to know Top 50 things that you can do with Excel Pivot Table!

 

Make sure to download our FREE PDF on the 101 Best Excel Tips & Tricks:

If you like this Excel tip, please share it
Select & Format Fields in Excel Pivot Tables | MyExcelOnline Select & Format Fields in Excel Pivot Tables | MyExcelOnline
Select & Format Fields in Excel Pivot Tables | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...