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 WORKBOOK


Here is our current Pivot Table:

Select & Format Fields in Excel Pivot Tables | MyExcelOnline

 

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 | MyExcelOnline

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 | MyExcelOnline

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 | MyExcelOnline

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.

Select & Format Fields in Excel Pivot Tables | MyExcelOnline

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

Select & Format Fields in Excel Pivot Tables | MyExcelOnline

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 | MyExcelOnline

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

Select & Format Fields in Excel Pivot Tables | MyExcelOnline

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

Select & Format Fields in Excel Pivot Tables | MyExcelOnline

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

select & format fields

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 | MyExcelOnline

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 | MyExcelOnline

 

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 | MyExcelOnline

The entire Pivot Table will be selected.

Select & Format Fields in Excel Pivot Tables | MyExcelOnline

 

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

 

HELPFUL RESOURCE:

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

Select & Format Fields in Excel Pivot Tables | MyExcelOnline

You can learn more about how to use Excel by viewing our FREE Excel webinar training on FormulasPivot TablesPower Query, and Macros & VBA!

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn