You are viewing the article How to Add Columns in Pivot Table at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 26,521 times.
This wikiHow teaches you how to create and insert new columns into a pivot table in Microsoft Excel using the Pivot Table tool. You can change existing rows, fields, or data into columns, or create columns of calculated data using a custom formula.
Steps
Convert data fields to columns
![Image titled Add a Cpumn in a Pivot Table Step 1](https://www.wikihow.com/images_en/thumb/a/a0/Add-a-Cpumn-in-a-Pivot-Table-Step-1-Version-4.jpg/v4-728px-Add-a-Cpumn-in-a-Pivot-Table-Step-1-Version-4.jpg)
- If you haven’t created a pivot table yet, open a new Excel document and create a Pivot Table before continuing.
![Image titled Add a Cpumn in a Pivot Table Step 2](https://www.wikihow.com/images_en/thumb/c/ce/Add-a-Cpumn-in-a-Pivot-Table-Step-2-Version-5.jpg/v4-728px-Add-a-Cpumn-in-a-Pivot-Table-Step-2-Version-5.jpg)
![Image titled Add a Cpumn in a Pivot Table Step 3](https://www.wikihow.com/images_en/thumb/c/cf/Add-a-Cpumn-in-a-Pivot-Table-Step-3-Version-5.jpg/v4-728px-Add-a-Cpumn-in-a-Pivot-Table-Step-3-Version-5.jpg)
- On some versions this tab is briefly named Analyze or displayed as an option under the “Pivot Table Tops” heading.
![Image titled Add a Cpumn in a Pivot Table Step 4](https://www.wikihow.com/images_en/thumb/7/7f/Add-a-Cpumn-in-a-Pivot-Table-Step-4-Version-5.jpg/v4-728px-Add-a-Cpumn-in-a-Pivot-Table-Step-4-Version-5.jpg)
![Image titled Add a Cpumn in a Pivot Table Step 5](https://www.wikihow.com/images_en/thumb/a/a9/Add-a-Cpumn-in-a-Pivot-Table-Step-5-Version-5.jpg/v4-728px-Add-a-Cpumn-in-a-Pivot-Table-Step-5-Version-5.jpg)
- Normally, non-numeric fields are added as rows, and metric fields are added as columns by default.
- You can uncheck the check box here at any time to delete the column.
![Image titled Add a Cpumn in a Pivot Table Step 6](https://www.wikihow.com/images_en/thumb/8/82/Add-a-Cpumn-in-a-Pivot-Table-Step-6-Version-4.jpg/v4-728px-Add-a-Cpumn-in-a-Pivot-Table-Step-6-Version-4.jpg)
Add field
![Image titled Add a Cpumn in a Pivot Table Step 7](https://www.wikihow.com/images_en/thumb/9/9e/Add-a-Cpumn-in-a-Pivot-Table-Step-7-Version-5.jpg/v4-728px-Add-a-Cpumn-in-a-Pivot-Table-Step-7-Version-5.jpg)
- If you haven’t created a pivot table yet, open a new Excel document and create a Pivot Table before continuing.
![Image titled Add a Cpumn in a Pivot Table Step 8](https://www.wikihow.com/images_en/thumb/b/b3/Add-a-Cpumn-in-a-Pivot-Table-Step-8-Version-5.jpg/v4-728px-Add-a-Cpumn-in-a-Pivot-Table-Step-8-Version-5.jpg)
![Image titled Add a Cpumn in a Pivot Table Step 9](https://www.wikihow.com/images_en/thumb/d/dc/Add-a-Cpumn-in-a-Pivot-Table-Step-9-Version-3.jpg/v4-728px-Add-a-Cpumn-in-a-Pivot-Table-Step-9-Version-3.jpg)
- On some versions this tab is briefly named Analyze or displayed as an option under the “Pivot Table Tops” heading.
![Image titled Add a Cpumn in a Pivot Table Step 10](https://www.wikihow.com/images_en/thumb/5/55/Add-a-Cpumn-in-a-Pivot-Table-Step-10.jpg/v4-728px-Add-a-Cpumn-in-a-Pivot-Table-Step-10.jpg)
![Image titled Add a Cpumn in a Pivot Table Step 11](https://www.wikihow.com/images_en/thumb/6/6c/Add-a-Cpumn-in-a-Pivot-Table-Step-11.jpg/v4-728px-Add-a-Cpumn-in-a-Pivot-Table-Step-11.jpg)
![Image titled Add a Cpumn in a Pivot Table Step 12](https://www.wikihow.com/images_en/thumb/d/d4/Add-a-Cpumn-in-a-Pivot-Table-Step-12.jpg/v4-728px-Add-a-Cpumn-in-a-Pivot-Table-Step-12.jpg)
![Image titled Add a Cpumn in a Pivot Table Step 13](https://www.wikihow.com/images_en/thumb/4/4b/Add-a-Cpumn-in-a-Pivot-Table-Step-13.jpg/v4-728px-Add-a-Cpumn-in-a-Pivot-Table-Step-13.jpg)
- Make sure you enter the formula to the right of the “=”.
- Or you can also select an existing column and add it to the formula as a value. Select the field you want to add to the data field section here and click Insert Field to insert it into the formula.
![Image titled Add a Cpumn in a Pivot Table Step 14](https://www.wikihow.com/images_en/thumb/8/8e/Add-a-Cpumn-in-a-Pivot-Table-Step-14.jpg/v4-728px-Add-a-Cpumn-in-a-Pivot-Table-Step-14.jpg)
Advice
- You need to make sure that you have backed up the original of the Excel document before proceeding to edit the pivot table.
Warning
- Don’t forget to save your work when you’re done.
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 26,521 times.
This wikiHow teaches you how to create and insert new columns into a pivot table in Microsoft Excel using the Pivot Table tool. You can change existing rows, fields, or data into columns, or create columns of calculated data using a custom formula.
Thank you for reading this post How to Add Columns in Pivot Table at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.
Related Search: