IT Employment

Ask something
Discussion Locked

Pivot Table formatting

0 helpful
1 reply

by topic

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I find (proably due the lack of my own skills)formatting a pivot table frustrating. The automated version are not alwasy suitable in a rofessional environment, as they tend to be a bit flashy rather than sophisticated. Can anyone assit how to best manually format a pivot table.

1 reply

by kees.valkenswaard

The newer your version of Excel the more complicated it can become to get at the right place. Basically invoke the wizard and try to find the array with rows, columns and data. Double click on any field in data and look for cell properties. There you can assign formatting to the data in the cell, including custom formatting.
Depending on your Excel version it may be possible to double click on a heading and do the same. Some outer cells may be formatted individually.

Be careful not to double click on a cell with data in the pivot table as this will invoke a new sheet with all data related to that sub selection. Actually that is a very handy method to prepare monthly sheets from a running list of data. You would have to make a grouping by month before doing that.

Need more explanation?
Mail me, but put also Q&A in the subject field, else the message will be deleted.
Good luck.

This discussion is closed to new replies.