Not really.

One way around it is to add an extra column. Then mark each of the rows you
want to fix.

Then you can sort by that column to group them all together, copy them, fix
them, and paste them right on top of the original range.

(But why not fix them in the original spot??)

Cene K wrote:

It seems like I'm missing something obvious here.

First, I have a sheet with a lot of phone numbers. quite a few are like
5561234567 and I needed all of them to be like (556) 123-4567. I used a filer
to find all the problem numbers and copied them to a new sheet where I fixed
them. Now I want to paste them back into the original sheet over the old
numbers. But when I try to paste, it pastes even to the rows that are hidden
by the filter. Is there a way to make it so excel ignores the hidden rows so
I can just paste one list on top of the other?

--

Dave Peterson