auto filter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 F5>Special>Visible cells only and run
your replace on those.


Gord Dibben Excel MVP
 
You must log in or register to reply here.

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

The next Grand Theft Auto title has been officially announced 0
How to bind filtered data in list box? 1
Auto filter hidden cells 1
Return value from the top of an auto filer list. 1
Problems with Auto Filter 2
data-auto filter not working properly? 10
Auto-filter selection 1
filter range 2

Back
Top