Home |
Search |
Today's Posts |
#1
|
|||
|
|||
auto filter
I have been using Find & Replace for years in a filtered worksheet and it
only updated the visible rows only. But today, it has updated all rows; ie includes those rows which are hidden. This has never happened before. I have looked in options for any flags to be set but then again the defult settings has not been changed since the last successful use of this functionality. Any hint or help. Cheers |
#2
|
|||
|
|||
You sure the rows are not visible due to a filter?
If they are then only visible cells should change. If the rows are actually hidden manually, they will change. A work-around for the second case is to F5SpecialVisible cells only and run your replace on those. Gord Dibben Excel MVP On Tue, 1 Mar 2005 17:43:02 -0800, "xlDummy" wrote: I have been using Find & Replace for years in a filtered worksheet and it only updated the visible rows only. But today, it has updated all rows; ie includes those rows which are hidden. This has never happened before. I have looked in options for any flags to be set but then again the defult settings has not been changed since the last successful use of this functionality. Any hint or help. Cheers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use auto filter on only 1 column in a spreadsheet? | Excel Worksheet Functions | |||
auto filter question | Excel Worksheet Functions | |||
auto filter question | Excel Worksheet Functions | |||
The Auto Filter button lost the column specified option. | Excel Worksheet Functions | |||
Why can't my macro use Auto Filter when I told the Sheet Protecti. | Excel Worksheet Functions |