![]() ![]() Instead of leaving those long default names in your pivot table, you can change the field headings. These long field names can make the columns wider than necessary, but if you try to change those names, Excel might show an error message - “PivotTable field name already exists.” For example, Quantity becomes “Sum of Quantity”, or “Count of Quantity”. When you add fields to the Values area, they are set as either Sum or Count, and the field is automatically renamed.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |