LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ana Ana is offline
external usenet poster
 
Posts: 44
Default Add new subtotal lines

Hi,
quick question on subtotals.

I have a huge list with subtotals and I need to know how I can insert new
subtotal lines.

For example, i have the following lines:
A
A
Subtotal A
C
C
Subtotal C

And I want to insert 3 new lines between A anc C for :
B
B
SubtotalB

I know I could remove subtotals, insert my new lines, and then re-run the
subtotals 'routine' again.. but was just wondering if there's a more elegant
way of inserting my new lines.

If this question has been asked before, just let me know - but just spent 10
min searching the 'archives' and I could't find a similar qustion.

Thanks!

AV
 
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
how do i copy the subtotal lines only without the details? jimmysyf Excel Discussion (Misc queries) 1 February 12th 08 06:16 PM
How do I copy just the collapsed subtotal lines? MTZgirl Excel Discussion (Misc queries) 3 November 2nd 07 09:32 PM
pasting to subtotal lines without replacing hidden -non-subtotal l harleydiva67 Excel Discussion (Misc queries) 1 October 12th 06 06:02 PM
Bolding the subtotal lines automaticlly When using the Subtotal fu 06Speed6 New Users to Excel 2 October 5th 06 03:52 PM
formatting subtotal lines david4141955 Excel Discussion (Misc queries) 2 August 14th 06 10:23 PM


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