ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   freeze or lock rows when using Auto filters (https://www.excelbanter.com/excel-programming/417470-freeze-lock-rows-when-using-auto-filters.html)

gr_jafari

freeze or lock rows when using Auto filters
 
There is a row as header in midle part of my list , when i use Auto Filter i
want this row not to be hide in any case , what can i do ?

Any help would be greatly appreciated
gr_jafari

Bernie Deitrick

freeze or lock rows when using Auto filters
 
Header rows belong at the top of your list. Use freeze panes to keep it visible at all times rather
than inserting a header row in the middle of your list.

HTH,
Bernie
MS Excel MVP


"gr_jafari" wrote in message
...
There is a row as header in midle part of my list , when i use Auto Filter i
want this row not to be hide in any case , what can i do ?

Any help would be greatly appreciated
gr_jafari





All times are GMT +1. The time now is 09:07 AM.

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