View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] gimme_this_gimme_that@yahoo.com is offline
external usenet poster
 
Posts: 129
Default Pivot Table Autoformatting without collapsing columns

I love how a pivot table looks if it's autoformatted.

But it collapses my columns and forces the user to select a single
column item from a drop down.

Is there a way to auto format a pivot table - but just add color - with
no column collapsing?

Thanks.