Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Special
I have selected the range of AD7:AD12 and would like to copy it and then
paste it over a range where I would like it to paste only in every sixth column. So for example I would select the pasting range to be AE7:AP12 and would only want the contents to paste in columns AJ and AP. Is there a paste special function or some other function that would allow me to accomplish this? Thank you in advance for your assistance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Special
SJT,
No. I think to do what you want automatically will require a macro. But you can manually select AJ7:AJ12 and AP7:AP12 (drag the first range, then holding Ctrl drag the second), then do a paste. -- Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "SJT" wrote in message ... I have selected the range of AD7:AD12 and would like to copy it and then paste it over a range where I would like it to paste only in every sixth column. So for example I would select the pasting range to be AE7:AP12 and would only want the contents to paste in columns AJ and AP. Is there a paste special function or some other function that would allow me to accomplish this? Thank you in advance for your assistance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Special
Thank you Earl for your response. A little confused was wondering if you
could clarify. Do I first select the range I wish to copy, AD7:AD12, and do a ctrl + c and then manually select the two ranges you named below? When you say "drag the first range" are you referring to AJ7:AJ12 and if so where am I dragging that to? If not which are you referring to and where should I drag it? Thanks again. "Earl Kiosterud" wrote: SJT, No. I think to do what you want automatically will require a macro. But you can manually select AJ7:AJ12 and AP7:AP12 (drag the first range, then holding Ctrl drag the second), then do a paste. -- Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "SJT" wrote in message ... I have selected the range of AD7:AD12 and would like to copy it and then paste it over a range where I would like it to paste only in every sixth column. So for example I would select the pasting range to be AE7:AP12 and would only want the contents to paste in columns AJ and AP. Is there a paste special function or some other function that would allow me to accomplish this? Thank you in advance for your assistance. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Special
SJT,
First select and copy AD7:AD12. Now select AE7:AE12 (drag through them). Now add AP7:AP12 to the selection by holding Ctrl as you drag through them. Don't let go of Ctrl until you've finished the drag and have released the mouse button. Now do an ordinary paste. -- Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "SJT" wrote in message ... Thank you Earl for your response. A little confused was wondering if you could clarify. Do I first select the range I wish to copy, AD7:AD12, and do a ctrl + c and then manually select the two ranges you named below? When you say "drag the first range" are you referring to AJ7:AJ12 and if so where am I dragging that to? If not which are you referring to and where should I drag it? Thanks again. "Earl Kiosterud" wrote: SJT, No. I think to do what you want automatically will require a macro. But you can manually select AJ7:AJ12 and AP7:AP12 (drag the first range, then holding Ctrl drag the second), then do a paste. -- Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "SJT" wrote in message ... I have selected the range of AD7:AD12 and would like to copy it and then paste it over a range where I would like it to paste only in every sixth column. So for example I would select the pasting range to be AE7:AP12 and would only want the contents to paste in columns AJ and AP. Is there a paste special function or some other function that would allow me to accomplish this? Thank you in advance for your assistance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste Special - Validation | Excel Discussion (Misc queries) | |||
Paste Special and Linking | Excel Discussion (Misc queries) | |||
Paste Special Problem | Excel Discussion (Misc queries) | |||
strange Paste special | Excel Discussion (Misc queries) | |||
Paste special treats cells as a picture | Excel Discussion (Misc queries) |