View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KM KM is offline
external usenet poster
 
Posts: 15
Default renaming column labels, pivots

Hi,
Could someone pls help me with this. I have "weeks" in my column labels.
Sum of 1-Jan-07 Sum of 8-Jan-07 Sum of 15-Jan-07 Sum of 22-Jan-07

As you can see, the lables come up as "sum 01-Jan07". How do I rename
several of these lables to show just "01 Jan07" without the "sum" in front of
it? I know how to rename single lables, but don't know how to do several at
one time.
Thanks
Kirthana