Im have an excell workbook that contains about 15 worsheets in it with different information in each. If want to copy the entire thing without having to copy and paste each worksheet idividually is there a way to do it in excell?? if so how do i do it? it takes me forever to do it individually !
2006-10-18 10:25:57 · 2 answers · asked by Ms.Budonkadonk 4 in Computers & Internet ➔ Other - Computers
While your current book is open...
-Go to "File Open" and open the book that you want to copy
-Go to "Window" and open a new window, and vertically or horiz. "split" them.
--You will now have BOTH open at the same time and you can copy one to the other by many means....
Hope THAT helps....
Good Luck!!!!
2006-10-19 01:25:54 · answer #1 · answered by bart4play 3 · 0⤊ 0⤋
Rather than copying it within Excel, shut down excel and go to where the excel file (with an xls extension) is saved. Copy that file and you get everything in it.
2006-10-18 17:36:03 · answer #2 · answered by dewcoons 7 · 0⤊ 0⤋