freeze or lock rows when using Auto filters

G

gr_jafari

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
 
B

Bernie Deitrick

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
 
Top