Posted to microsoft.public.excel.misc

external usenet poster

Posts: 15

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
How do stop Excel changing column widths when doing pivots?	CB	Excel Discussion (Misc queries)	1	June 27th 06 08:15 PM
Renaming Column	ConfusedStudent	Excel Worksheet Functions	2	January 17th 06 02:28 PM
Renaming Column	ConfusedStudent	Excel Discussion (Misc queries)	2	January 17th 06 02:27 PM
Renaming Column	ConfusedStudent	Excel Worksheet Functions	0	January 17th 06 01:51 PM
renaming data labels by different cells than source data	Darren	Charts and Charting in Excel	4	January 12th 06 10:35 AM

All times are GMT +1. The time now is 08:57 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us