excel pivottable question

[Pia Cox]

Does anyone know if the underlying pivottable columns can be formatted to
wrap? I have the original spreadsheet that I am creating the Pivottable
from formatted the way I want the underlying spreadsheet to look but, after
creating the pivottable the underlying data seems to format itself.
Thanks for any help in advance!

 

[David McRitchie]

Hi Pia,
You can format the resulting Pivot Table however you want
after it's creation. So you would probably want to create a macro,
in fact you might even be able to actually use the output from
recording a macro if you avoid addressing specific rows.
http://www.mvps.org/dmcritchie/excel/getstarted.htm