Excel 2007 Replace All With Filters

[psubsee2002]

I recently upgraded to Excel 2007, and I have encountered an issue that did
not occur with previous versions of Excel.

When I filter a column on a specific value, and the do a "find" and "replace
all", I noticed excel now replaces that data in the entire spreadsheet, and
not just on the filtered data.

Has anyone else encountered this and is there a workaround?

 

[psubsee2002]

I've noticed this issue also occurs with deleting rows with filtered data.
In previous versions, if I were to select all rows from a filtered list and
deleted the rows, it would only delete the filtered rows. In 2007, it
deleted all rows.

I've noticed that if I apply a 2nd filter to another column, Excel behaves
as it did in previous versions, but that is a major inconvenience. I'm
hoping there is another workaround, or I will have to downgrade to a previous
version.

 

[Peo Sjoblom]

I gave up on 2007 and only use it if I have to but what happens if you press
F5, click special and visible cells only,
then delete or copy?


--


Regards,


Peo Sjoblom