this should be easy - filtered rows
 

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?

this should be easy - filtered rows
 

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

this should be easy - filtered rows
 

Can you just apply the built-in format? Edit Format Cells, go to the
numbers tab, select the Special category and choose Phone Number.

"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?

this should be easy - filtered rows
 

That did the trick. Thanks.

BTW, the reason I didn't fix them in the original sheet is because I used a
formula to fix them, and when I copy and try to paste values, it treats it
like muliple selections and won't let me. Since I had better than 1200
numbers to fix, I figured it would be faster to do it in another sheet than
to select, copy, and paste values for each individual number. Unless there's
a workaround for that too.

"Dave Peterson" wrote:

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

this should be easy - filtered rows
 

If you have that indicator column and filter by that, then you could use another
helper column and put your formula in there (I don't quite know how you're
fixing it).

But if you filter that range, then apply the formula to one of the visible rows,
you can drag it down the column--only the visible cells will be changed.



Cene K wrote:

That did the trick. Thanks.

BTW, the reason I didn't fix them in the original sheet is because I used a
formula to fix them, and when I copy and try to paste values, it treats it
like muliple selections and won't let me. Since I had better than 1200
numbers to fix, I figured it would be faster to do it in another sheet than
to select, copy, and paste values for each individual number. Unless there's
a workaround for that too.

"Dave Peterson" wrote:

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


--

Dave Peterson