Hide Raws even the Auto Filter is active

[Saji]

How to hide the raws permentanly of the Excel sheet 2003, even when the
filter is active?

If the filter is active, the hidden raws again unhide when we select "All"
option in the Auto Filter.

 

[Paul C]

You can set the row height to 1 (0 won't work). Not really hidden, but
visually the same result.

 

[Ashish Mathur]

Hi,

I haven't tried this but you could hide the rows and then protect the
workbook structure. Please note that such protection will also disable
other features such as sheet renaming, moving

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Saji]

Hi Ashish,

Protect working book structure function does not block the hidden raws from
showing when we select "All" in Auto filter function.

Saji