Excel question

[merriwether]

Excel question#1

Posted: 4/5/09 at 3:25pm

If you have several Excel spreadsheets saved individually in one folder, is it possible to merge them into one workbook where each file is a separate tab in the workbook?

[singtopher]

re: Excel question#2

Posted: 4/5/09 at 3:33pm

I'm not sure about merging, but you can just copy/paste.

"If this is going to be a Christian nation that doesn't help the poor, either we have to pretend that Jesus was just as selfish as we are, or we've got to acknowledge that He commanded us to love the poor and serve the needy without condition and then admit that we just don't want to do it." -Stephen Colbert

[ashley0139]

re: Excel question#2

Posted: 4/5/09 at 6:53pm

I'm not sure, but sometime the copying and pasting messes up the cells. The cells in the new book sometimes don't change to the size they were in the old book and then you have to go back and change them. (if anyone has suggestions for this I would love them, ha)

"This table, he is over one hundred years old. If I could, I would take an old gramophone needle and run it along the surface of the wood. To hear the music of the voices. All that was said." - Doug Wright, I Am My Own Wife

[frogs_fan85]

re: Excel question#3

Posted: 4/5/09 at 7:10pm

If you use CTRL+A and then do the copy/paste method you should be ok. The first step should pick up all of the formatting of the original cells and hopefully they will translate correctly into the new file.

[mlsheehan]

re: Excel question#4

Posted: 4/5/09 at 10:29pm

You can copy or move a spreadsheet from one file to another...

If you have both files open...

>right click on the tab (at the bottom of the spreadsheet) of the spreadsheet that you want to copy..

>select "move or copy"

>if you want to copy, check the box by "Create a copy"
(if you do not do this, it will move the sheet out of the file)

>toward the top to the dialog box there is a drop down box titled "To book:", click on the down arrow

>select the name of the file (which needs to be open) where you want to move the sheet (or select "(new book)" if you want to move to a completely new file)

JUST A NOTE: THIS WILL ONLY MOVE THE FIRST 255 CHARACTERS IN A CELL. SO IF YOU HAVE CELLS WITH A LOT OF TEXT, IT WILL TRUNCATE THEM AT 255 CHARACTERS. However, it is usually only a couple of cells that have this many characters, (and if you copied) you can go to the original and do a simple "copy" (from the original cell) and "paste" (to the duplicate cell in the new file).

Other than the above, this will keep formating and formulas working.

I hope that was helpful...

Good luck.