Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ivy Ivy is offline
external usenet poster
 
Posts: 7
Default Formatting List Subtotal Headings

I have used the vlookup function to add data from one spreadsheet to another.
I then used the list subtotal function. When I collapse the data to create
a summary report, the subtotal row automatically adds the function to the
data name, e.g. tables count. Is it possible to modify this label? My pivot
table cell reference would have to be changed for the subtotal rows. I have
about 25,000 rows of data.

Thank you.
--
Ivy
Reply
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
subtotal formatting ab3d4u Excel Worksheet Functions 1 August 30th 07 11:04 PM
PivotTables headings formatting ? Olle Excel Discussion (Misc queries) 0 November 13th 06 09:55 AM
How do I keep column headings from showing on a list? Kikipelli2000 Excel Worksheet Functions 2 June 9th 06 10:13 AM
row headings on pages - proper formatting in page set up connie Excel Discussion (Misc queries) 1 May 18th 06 07:13 PM
How do you use "Block Formatting" for column headings? AlanY Excel Discussion (Misc queries) 1 August 24th 05 07:09 PM


All times are GMT +1. The time now is 12:32 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"