| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste data to a filtered column, pasting to visible cells only
I have a spreadsheet of several regions, with the same measurements in each
Region. A number of people send me the specific measurements they are responsible for in the same Region order. I'd like to filter on the measurement, and then copy and paste. When I do so, it copies to the hidden cells. Any way I can get it to copy to just the visible cells? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paste data to a filtered column, pasting to visible cells only
Not possible
-- Regards, Peo Sjoblom "Shinka" wrote in message ... I have a spreadsheet of several regions, with the same measurements in each Region. A number of people send me the specific measurements they are responsible for in the same Region order. I'd like to filter on the measurement, and then copy and paste. When I do so, it copies to the hidden cells. Any way I can get it to copy to just the visible cells? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paste data to a filtered column, pasting to visible cells only
Are you sure? This seems like such a useful thing to be able to do..
"Peo Sjoblom" wrote: Not possible -- Regards, Peo Sjoblom "Shinka" wrote in message ... I have a spreadsheet of several regions, with the same measurements in each Region. A number of people send me the specific measurements they are responsible for in the same Region order. I'd like to filter on the measurement, and then copy and paste. When I do so, it copies to the hidden cells. Any way I can get it to copy to just the visible cells? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paste data to a filtered column, pasting to visible cells only
I like to sort my data to group all the rows that would be visible. Then I can
just paste to those visible rows. And then I resort it to its "natural" order. Shinka wrote: Are you sure? This seems like such a useful thing to be able to do.. "Peo Sjoblom" wrote: Not possible -- Regards, Peo Sjoblom "Shinka" wrote in message ... I have a spreadsheet of several regions, with the same measurements in each Region. A number of people send me the specific measurements they are responsible for in the same Region order. I'd like to filter on the measurement, and then copy and paste. When I do so, it copies to the hidden cells. Any way I can get it to copy to just the visible cells? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| paste data over hidden cells that are filtered | Excel Worksheet Functions | |||
| countif only visible cells (filtered) | Excel Worksheet Functions | |||
| Copy visible cells on Filtered data | Excel Discussion (Misc queries) | |||
| Paste Data into Contiguous (Visible) Cells | New Users to Excel | |||
| Pasting on Filtered Data Sheets without pasting onto hidden cells | Excel Discussion (Misc queries) | |||
Linear Mode
