Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Paste Data into Contiguous (Visible) Cells
I am trying to paste data from a set of contiguous cells in one sheet into some cells in anther sheet. I have hidden the columns I do not want to paste the data so that the selection that I would want to paste into looks contiguous. I was hoping that Excel would see it that way also and just paste one cell after another. However, it chooses to paste to the hidden cells, which is not what I want. Does anyone know how (without writing a macro) I can paste into cells that are not contiguous normally, but appear contiguous when some columns are hidden? Thanks in advance. Trevor -- trev_sk8r ------------------------------------------------------------------------ trev_sk8r's Profile: http://www.excelforum.com/member.php...o&userid=35509 View this thread: http://www.excelforum.com/showthread...hreadid=552817 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Paste Data into Contiguous (Visible) Cells
See the link below, i just tested it and it works like a charm.
http://office.microsoft.com/en-us/as...x#VisibleCells "trev_sk8r" wrote: I am trying to paste data from a set of contiguous cells in one sheet into some cells in anther sheet. I have hidden the columns I do not want to paste the data so that the selection that I would want to paste into looks contiguous. I was hoping that Excel would see it that way also and just paste one cell after another. However, it chooses to paste to the hidden cells, which is not what I want. Does anyone know how (without writing a macro) I can paste into cells that are not contiguous normally, but appear contiguous when some columns are hidden? Thanks in advance. Trevor -- trev_sk8r ------------------------------------------------------------------------ trev_sk8r's Profile: http://www.excelforum.com/member.php...o&userid=35509 View this thread: http://www.excelforum.com/showthread...hreadid=552817 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
How do I paste data from multiple cells into one cell | Excel Discussion (Misc queries) | |||
copy and paste between cells that have data | Excel Worksheet Functions | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) |