I have quite a complicated Excel document, no calculations, just boxes and formatting. Can I convert this to a Word document?
2006-08-21 04:53:11 · 6 answers · asked by Mandy R 2 in Computers & Internet ➔ Software
Hi,
Select All in your Excel worksheet (eg by pressing Ctrl+A) on your keyboard.
Open a blank Word document.
Go to Edit menu, select Paste Special. It will open a box with a list of options - you can either paste as a picture metafile but I would recommend the top option which is paste as an Excel document.
If it does not fit your page margins, you can either resize the newly pasted Excel doc by highlighting it and selecting the corners of it to resize it or just change the page margins in the rulers of the Word document itself.
Or if it needs to go on more than one page of a Word document - just select one 'page' at a time in Excel and paste special each one.
If it is too wide, I would recommend changing your Word document to landscape which you can do by selecting File menu in your Word document and select Page setup.
It will have affect the file size - you can check this by saving the document and selecting File menu, select Properties and the General tab. This will give you the file size for your document.
You can use Paste Special to paste most MS Office Documents into another Document such as Word to Excel, Excel to Word, Word to Powerpoint, Excel to Powerpoint.
2006-08-21 07:32:02 · answer #1 · answered by racingshoes 2 · 0⤊ 0⤋
Provided your page margins for Excel are the same as the page margings in Word you can copy and paste. I have used this method a lot. If your spreadsheet file is very complicated you could save the Excel file as a HTML file and then open it in Word and then save it as a Word document.
2006-08-21 05:12:14 · answer #2 · answered by Anonymous · 0⤊ 0⤋
Select the cells in Excel you want to copy, then press copy. Go into Word, open a new document and press paste. This puts all the data into a table in Word. If you want to get it out of the table and just into text, highlight the table, click on table on the menu bar and select "table to text" and follow the instructions.
2006-08-22 05:55:21 · answer #3 · answered by Lewiy 3 · 0⤊ 0⤋
you can copy paste entire table as excell control in word. mark all you need in excell and copy it in word - should work.
2006-08-21 05:05:31 · answer #4 · answered by Bruno 3 · 0⤊ 0⤋
There may be an easier method, but I would save the .xls file as .html and then open the .html in word...
2006-08-21 05:01:14 · answer #5 · answered by Brad C 2 · 0⤊ 0⤋
You can also just copy -> paste if it's just a simple xls file.
2006-08-21 05:07:21 · answer #6 · answered by BRKings20 2 · 0⤊ 0⤋