Insert a Word Document (2003)

Topic

New Reply

I have an investigation inExcel. I have a statement in Word that I need to paste into a worksheet in Excel. One paragraph in the Word document cuts off because of it’s length. Any suggestions on how I can paste or insert this document into Excel and keep the layout. The Word document prints out on two pages.

Reply | Quote

Replies

I wouldn’t insert a Word document in an Excel worksheet. Or if you really must, copy and paste it in smaller parts.

Reply | Quote

Yes I agree,
I got it done by going into word and splitting the monster paragragh into smaller ones-then copying and pasting into Excel -then formatting the cells in Excel
A chore but all the information is there, thanks for the tip.

Reply | Quote

You can also paste a page from a Word document as a Word object. It’ll float above the worksheet.

Reply | Quote

Hi Hans,

If I am reading this right you can embed a word document in an excel spread sheet?

how do I do this?

Thanks

Reply | Quote

For example:

Select Insert | Object…
Activate the 2nd tab.
Click Browse…
Select the document and click Insert.
Back in the Insert Object dialog, specify whether you want to embed or link the document, and whether you want to display it as an icon.
Finally, click OK.
The user can double click the inserted object to view the entire document (and to edit it).

Instead of embedding or linking a document, you can also insert a clickable hyperlink to a document in a cell (Insert | Hyperlink…)

Reply | Quote

This highlights one limitation of the current MS Office that we had in an older version which had Binders. I miss being able to group related documents, spreadsheets, and such into a single file. I wish there were a “Binder” functionality in the current (or future) version of MS Office.

Reply | Quote

It was a nice feature, but I don’t think it’ll come back…

Reply | Quote

thanks Hans

Reply | Quote

A related question:
If you copy a worksheet from one workbook to another, cell contents higher than some number (it may have been 255 characters) are truncated. Is there any way to change this limit or is one forced to copy cell by cell to the new workbook when high character count is involved?

Paul

Reply | Quote

There is no need to copy cell by cell. You can select all cells in a worksheet (Ctrl+A), then copy and paste into a worksheet in another workbook. Cells will not be truncated at 255 characters.

Reply | Quote

The way to get around the limit is to, instead of copying the worksheet, create a blank sheet in the 2nd workbook, then in the source, use Ctrl-A (or choose the intersection of row/column headers) to select all the cells, then copy this and paste it into cell A1 of the blank sheet.

Steve

Reply | Quote

Thanks Steve & Hans !

Paul

Reply | Quote