I have 4 different documents on my computer that I need to put on one sheet. I use excell and how do I get them on one sheet. Don't get me wrong. It will be 4 pages when printed out but how do I get them where if I click on it, it will be all there on one sheet.
2007-08-29 14:52:14 · 4 answers · asked by birdlady 1 in Computers & Internet ➔ Software
www.microsoft.com
2007-08-29 14:55:48 · answer #1 · answered by Strive to Survive 2 · 0⤊ 2⤋
Hopefully, your 4 worksheets have the same structure - that is, same number of columns, same headings, same width...
All you have to do is open one worksheet, select all the data (not necessary to copy the headings) - then paste in the first blank row following the existing data.
When all has been read in, click the "table select" button (to the left of A, and above 1), click Format, Column, autofit.
You cannot easily join worksheets if the structure does not match. You can, however, painstakingly copy one column at a time into the appropriate column if the headers do not match.
2007-08-30 00:36:22 · answer #2 · answered by TheHumbleOne 7 · 0⤊ 0⤋
Create one new blank Spread sheet
Open each one of the four..
On each one.. press CTRL+A to highlight all the data
Press CTRL+C to copy
go to the new spread sheet.
put the cursor on the next blank line
press CTRL+V to paste
2007-08-29 21:58:57 · answer #3 · answered by xhawkx 3 · 1⤊ 0⤋
what's wrong with Copy & Paste?
2007-08-29 21:58:41 · answer #4 · answered by Den B7 7 · 0⤊ 0⤋