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 Buddyfarr6,850 pts.