Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Hide Raws even the Auto Filter is active

0 views
Skip to first unread message

Saji

unread,
Jan 7, 2010, 2:45:01 AM1/7/10
to
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

unread,
Jan 7, 2010, 3:19:02 PM1/7/10
to
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.

Ashish Mathur

unread,
Jan 9, 2010, 4:43:51 AM1/9/10
to
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" <Sa...@discussions.microsoft.com> wrote in message
news:6F020795-27FE-483E...@microsoft.com...

0 new messages