Hide Raws even the Auto Filter is active

S

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.
 
P

Paul C

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

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
 
S

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to look up each Excel workbook raw in another. 1
How to deinterlace MTS/M2TS video,remove interlaces 1
30 minutes to Filter in Excel 2007 1
protecting a range of raws and columns with formula in Excel sheet 2
Using Hide, Unhide, and auto filter - select all on a protected sh 1
Auto Filter Function getting 'stuck' 3
Additional raws in some part of excel sheet 3
How to color a row ? 3

Top