toggle total row

  • Thread starter Thread starter rusty
  • Start date Start date
R

rusty

? is there any way to lock the position of the row where the total is rather
than it moving to the bottom of the list when filter/sort is used
thanks
 
Leave a blank row between the data and the total row.
It will not be included in the filter or sort unless you select it.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"rusty"
wrote in message
? is there any way to lock the position of the row where the total is rather
than it moving to the bottom of the list when filter/sort is used
thanks
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
writing a sort macro 2
Hold conditional formatting when sorting filtered data 1
Excel VBA - counting cells by colors and names to it in two different rows. 0
Add columns to reach a predetermined value 2
keep total formulas / rows when apply filter 1
I can't see Grand total rows even though the option's switched on 2
the row has disappeared and it's not hiding 3

Back
Top