Hide Raws even the Auto Filter is active
 

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.

Hide Raws even the Auto Filter is active
 

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


--
If this helps, please remember to click yes.


"Saji" wrote:

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.

Hide Raws even the Auto Filter is active
 

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" wrote in message
...
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.

Hide Raws even the Auto Filter is active
 

Hi Ashish,

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

Saji

"Ashish Mathur" wrote:

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" wrote in message
...
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.