Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hidden rows reappearing when using filter
Hi,
I have hidden some rows in a document which also has filters when I use the filters to get to a particular data and then go back to viewing 'All' data the hidden rows become unhidden, how can I stop this from happening?, any suggestions? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hidden rows reappearing when using filter
Hi Betty,
I've found this to be a problem in the past. My work around was to either remove the entry that you've hidden, or, to pivot the data rather than filter it. That way you can 'de-select' the entry you don't want in the pivot table. "Betty" wrote: Hi, I have hidden some rows in a document which also has filters when I use the filters to get to a particular data and then go back to viewing 'All' data the hidden rows become unhidden, how can I stop this from happening?, any suggestions? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hidden rows reappearing when using filter
Hi,
FYI - in 2007 this is no longer a problem because you can check and uncheck any filtered items you want. In 2003 I think the Pivot Table solution is a nice one. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Betty" wrote: Hi, I have hidden some rows in a document which also has filters when I use the filters to get to a particular data and then go back to viewing 'All' data the hidden rows become unhidden, how can I stop this from happening?, any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hidden rows reappearing when using filter | Excel Worksheet Functions | |||
Stop rows that i have hidden unhidding when i filter in excel | Excel Worksheet Functions | |||
Hidden Rows with Auto-Filter | Excel Worksheet Functions | |||
How to paste data over the hidden rows in a sheet with a filter | Excel Discussion (Misc queries) | |||
I need my Hidden Rows to stay hidden when I print the sheet. | Excel Discussion (Misc queries) |