Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pasting into a filtered sheet
I have an Excel spreadsheet where some of the rows are not visible as they
are auto-filtered out. I have a column of 20 cells from another sheet that I want to paste in to cells in the top 20 visible rows of the first sheet. However, whenever I try this using Paste or Paste Values, it fills the top 20 cells including the invisible rows. Is there any way I can just paste into the visible rows please? TIA V |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pasting into a filtered sheet
You cannot do this because the range you are pasting to must be the
same size and shape as the range you are copying from. Also, you cannot copy from multiple selection range to another multiple- selection range. Francis Hayes www.TheExcelAddict.com |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pasting into a filtered sheet
Maybe you can sort your "to" data so that the range to be pasted is contiguous.
Then do the copy|Paste and then resort your data to put it in the order you like. Victor Delta wrote: I have an Excel spreadsheet where some of the rows are not visible as they are auto-filtered out. I have a column of 20 cells from another sheet that I want to paste in to cells in the top 20 visible rows of the first sheet. However, whenever I try this using Paste or Paste Values, it fills the top 20 cells including the invisible rows. Is there any way I can just paste into the visible rows please? TIA V -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pasting into a filtered sheet
I feared this might be the case. Many thanks to both of you for your
replies. V "Dave Peterson" wrote in message ... Maybe you can sort your "to" data so that the range to be pasted is contiguous. Then do the copy|Paste and then resort your data to put it in the order you like. Victor Delta wrote: I have an Excel spreadsheet where some of the rows are not visible as they are auto-filtered out. I have a column of 20 cells from another sheet that I want to paste in to cells in the top 20 visible rows of the first sheet. However, whenever I try this using Paste or Paste Values, it fills the top 20 cells including the invisible rows. Is there any way I can just paste into the visible rows please? TIA V -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting filtered rows | Excel Discussion (Misc queries) | |||
filtered pasting | Excel Discussion (Misc queries) | |||
Pasting on Filtered Data Sheets without pasting onto hidden cells | Excel Discussion (Misc queries) | |||
Pasting onto filtered cells | Excel Worksheet Functions | |||
Pasting onto filtered cells | Excel Worksheet Functions |