Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Special
I would like to take the contents from b2:b15 and move them to a2:a15 and
have the contents from a2:a15 move one column over to b2:b15 w/o adding a column and then moving the contents. Is there a way to do this w/ Paste Special or some other function. Thank you in advance for your assistance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Special
Select b2:b15. Edit Cut. Select a2:a15. Edit Insert Cut Cells.
"SJT" wrote: I would like to take the contents from b2:b15 and move them to a2:a15 and have the contents from a2:a15 move one column over to b2:b15 w/o adding a column and then moving the contents. Is there a way to do this w/ Paste Special or some other function. Thank you in advance for your assistance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Special
I can't speak confidently about older versions, but in Excel 2003, you could
use the Office Clipboard. 1. Click Edit/Office Clipboard. 2. Highlight and copy b2:b15. It will appear in the Clipboard panel on the right. 3. Highlight and Copy a2:a15. It will aslo appear in the Clipboard. 4. With a2:a15 still highlighted, click on the first item in the clipboard which was the original data in col b. The col b data willbe pasted into the cells. 5. Repeat this procedure to past the col a data into the col b cells. Hope this works out for you. "SJT" wrote: I would like to take the contents from b2:b15 and move them to a2:a15 and have the contents from a2:a15 move one column over to b2:b15 w/o adding a column and then moving the contents. Is there a way to do this w/ Paste Special or some other function. 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) |