Does anyone know how to copy all or portions of an Excel spreadsheet into a new Excel Document without losing the cell formatting or the formulas I have created? I have tried copying and pasting, but then the formulas show up as #####, and I lose all cell formatting. Thanks in advance to whomever is smart enough to help with this one! :)
2006-08-28 07:58:14 · 7 answers · asked by just me 1 in Computers & Internet ➔ Software
You can copy and paste any portion of an excel spreadsheet into a new Excel document by selecting, then copying. When pasting into a new document , select A1, choose edit from the menu and then paste special. Choose formatting, this allows you to paste with formatting.
To copy the entire spreadsheet click on the select all button which is the black button located to the left of the column heading. Select cell A1 and then paste. You maintain the formatting this way.
http://www.worldstart.com/tips/tips.php/837
2006-08-28 08:35:42 · answer #1 · answered by tina_jnsn 1 · 0⤊ 0⤋
At the bottom of the spreadsheet, you should see sheet tabs (Sheet1, Sheet2, Sheet3). Right click on the current tab and select Move or Copy. Select New Book from the dropdown menu and check the Create a copy box. This will copy the entire sheet into the new book, including all the formulas and formatting.
2006-08-28 08:04:31 · answer #2 · answered by Anonymous · 0⤊ 0⤋
Go to the bottom of the spreadsheet and right-click on the tab for that sheet
Select Move or Copy...
Select that you want to copy that sheet and whether into a new page in the same file or into a new file
If you do not want the whole page, go into the copy and delete whatever you do not need
2006-08-28 08:03:57 · answer #3 · answered by dewcoons 7 · 0⤊ 0⤋
Select what you wish to copy, navigate to new sheet, and click Edit, Paste Special. In the first section of the dialogus box, make sure All is marked. Click OK.
Also, ##### usually indicates that a number cannot be displayed in the amount of space provided--you need to widen the column.
2006-08-28 08:13:03 · answer #4 · answered by williamh772 5 · 0⤊ 0⤋
When you get ######## in excel it shows that the rows & Columns are not wide enough to show the contents. Why don't you create a new page and copy all onto this then point your mouse in between the columns at the top and double click to auto expand the columns to the right size.
Hope this helps.
G
2006-08-28 08:08:20 · answer #5 · answered by starman 3 · 0⤊ 0⤋
"######" means that the column is too narrow to display the data. Try widening the columns.
When pasting, go to the Edit menu and choose Paste Special. There are advanced pasting options to acheive your desired result.
2006-08-28 08:03:25 · answer #6 · answered by IT Pro 6 · 0⤊ 0⤋
Did you try Edit>Paste Special...>Excel Spreadsheet?
Havent used it in a while, but i think that's how its done.
2006-08-28 08:03:48 · answer #7 · answered by haha 4 · 0⤊ 0⤋