Home > IT Answers > Microsoft Windows > Excel – Question
Nadeemzuhair
10 pts.
 Excel – Question
Excel 2003
How can I copy multiple selections in Excel worksheet

Software/Hardware used:
ASKED: February 22, 2008  2:44 AM
UPDATED: February 22, 2008  4:25 AM
RELATED QUESTIONS
Answer Wiki:
If you hold down the control key when selecting each then all should highlight. then do EDIT > COPY from the menu or right click and copy, then paste to new sheet. if all items you want to copy are in a row then you can highlight the first one, hold down shift and click on the last one. it will highlight everything between the two items. then copy as above.
Last Wiki Answer Submitted:  February 22, 2008  2:51 am  by  Buddyfarr   6,850 pts.
All Answer Wiki Contributors:  Buddyfarr   6,850 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Buddy is correct here. Remember, sometimes when you select a section of a workbook you have to paste the copied data into a selection of the same size. If you have problems pasting just be sure to select the same size area.

Also, when you paste multiple selections it pastes them in the area where you choose to paste them, but it pasts them in consecutive columns or rows (any space in between the originals is lost.)

Jerry Lees
 5,320 pts.