| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort (or group?) a spreadsheet by similar rows? | Excel Worksheet Functions | |||
| How to number rows after data has been filtered? | Excel Discussion (Misc queries) | |||
| Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
| flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) | |||
| How can I make autofilter show the filtered number of rows | Excel Worksheet Functions | |||
Threaded Mode
