| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Active Cell in Auto Filter | Excel Discussion (Misc queries) | |||
| Using Hide, Unhide, and auto filter - select all on a protected sh | Excel Worksheet Functions | |||
| how to hide raws and use password | Excel Worksheet Functions | |||
| how to hide raws and use password | Excel Discussion (Misc queries) | |||
| Active Hide Emtpy Cells | Excel Discussion (Misc queries) | |||
Hybrid Mode
