LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Pivot Table column sizing

I searched for prior issues about column sizing in pivot tables and came
across one which stated that the user should uncheck the AutoFormat Table and
keep the Preserve Formatting checked in the table options. I did as
suggested and wound up with the pivot table saving the column sizing I wanted
but "erased" the other formatting implemented by the AutoFormat template I
picked (as in colors and bolding). Is there any way I can use the AutoFormat
templates and "modify" somewhat without losing my adjustments everytime I
refresh?

Thank you
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table - how to add column on the same row Negda Excel Worksheet Functions 2 April 5th 08 06:57 PM
Sorting a Pivot Table Column that is not the first column... [email protected] Excel Worksheet Functions 1 October 10th 07 09:02 PM
Pivot table add one column Daniel Charts and Charting in Excel 0 July 25th 07 12:00 AM
Column Auto Sizing oranskeer Excel Discussion (Misc queries) 3 December 15th 06 03:24 PM
sizing different cells in same column cmkogos2 Excel Discussion (Misc queries) 2 May 2nd 05 09:48 PM


All times are GMT +1. The time now is 03:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright 2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"