Pinterest Pixel

Move and Remove Fields and Items in Excel Pivot Tables

Bryan
Pivot tables are considered a great tool for data handling due to their large capacity for customizing the field arrangement.
You can easily move and remove fields and items in your pivot table for managing and displaying your data according to your requirements.
Move and Remove Fields and Items in Excel Pivot Tables | MyExcelOnline Move and Remove Fields and Items in Excel Pivot Tables | MyExcelOnline

The best thing is it gives you full control over how you want your final table to look. Let us see how we can achieve this!

 

Exercise Workbook:

download excel workbookMove-Remove-Fields-and-Items.xlsx


Here is how our Pivot Table is currently setup:

Move and Remove Fields and Items in Excel Pivot Tables

Move and Remove Fields and Items in Excel Pivot Tables

STEP 1: Let us work with rows first. Let’s move the TONIC row down one spot.

Right click on the TONIC row and go to Move > Move “TONIC” Down

Move and Remove Fields and Items in Excel Pivot Tables

It now moved one spot below

Move and Remove Fields and Items in Excel Pivot Tables

STEP 2: You can also move it by typing the value as well!

Let us move it to the last Product row. Type in TONIC at the last Product row.

Move and Remove Fields and Items in Excel Pivot Tables

And just like that it has now moved to the bottom!

Move and Remove Fields and Items in Excel Pivot Tables

STEP 3: What if we want to update the hierarchy of our Fields? Right click on any Product row and go to Move > Move “PRODUCTS” To End

Move and Remove Fields and Items in Excel Pivot Tables

Now it’s the Salesperson that is now showing the Product Details

Move and Remove Fields and Items in Excel Pivot Tables

STEP 4: The same tips apply for the columns as well. Let us try it out!

Let’s move the 2014 column to the very end.

Right click on the 2014 column and go to Move > Move “2014” to End

Move and Remove Fields and Items in Excel Pivot Tables

And there you have it!

Move and Remove Fields and Items in Excel Pivot Tables

STEP 5: To remove the field. You simply right click on the field and select Remove.

In our scenario, right click on BOTTLES and select Remove “PRODUCTS”

Move and Remove Fields and Items in Excel Pivot Tables

You are now left with the Salesperson field for your rows!

Move and Remove Fields and Items in Excel Pivot Tables

This is how you easily move and remove fields and items in Pivot Table. Click Here to know all about this powerful tool – Excel Pivot Tables!

 

Make sure to download our FREE PDF on the 333 Excel keyboard Shortcuts here:

If you like this Excel tip, please share it
Move and Remove Fields and Items in Excel Pivot Tables | MyExcelOnline
Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.

See also  Repeat All Item Labels In An Excel Pivot Table

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