ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   toggle total row (https://www.excelbanter.com/excel-discussion-misc-queries/179507-toggle-total-row.html)

Rusty

toggle total row
 
? 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

Jim Cone

toggle total row
 
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


All times are GMT +1. The time now is 08:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com