Hi Wilson,
255 is the maximum width of cell, you can turn on cell wrap either
by format, cells, alignment, wrap text
or by use of Alt+Enter which gets you a new line and an automatic wrap text formatting.
--
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"WIlson" wrote in message ...
The results of a pivot table (when clicking on it) generates a new worksheet.
1) I would like to format that new worksheet template. How ? and where is it ?
2) Some of the fields ae trucanting at 255 , how can I expand that ?
Any ideas?
Thank you kindly , in advance.