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?