Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
achidsey
 
Posts: n/a
Default Subtotal results without word "Total"

Excel Experts

When inserting Subtotals, isn't there a way to get the results without
having the word "Total" appended to each Totaled Item?

I knew this once.

Thanks
Alan


--
achidsey
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

I don't think so, but you could always just select that column
Edit|replace
what: _Total (underscore represents a space)
with: (leave blank)
replace all

achidsey wrote:

Excel Experts

When inserting Subtotals, isn't there a way to get the results without
having the word "Total" appended to each Totaled Item?

I knew this once.

Thanks
Alan

--
achidsey


--

Dave Peterson
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
Pasting Subtotal Results tchen Excel Discussion (Misc queries) 1 August 8th 05 09:49 PM
How to I get a total word count in Excel? JK Excel Discussion (Misc queries) 1 July 6th 05 04:19 PM
Remove the word 'total' from subtotals yahoo Excel Discussion (Misc queries) 2 February 13th 05 01:26 AM
keep a running total of my formula results after each (F9) Souvien Excel Discussion (Misc queries) 1 January 23rd 05 01:59 AM
Subtotal of Subtotal displays Grand Total in wrong row Thomas Born Excel Worksheet Functions 5 January 6th 05 01:46 PM


All times are GMT +1. The time now is 11:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"