word/excel help

[woodpecker 0]

I want to add an excel spreadsheet to my work document.

How the hell do I do this. I insert a page break, then what?

SONIC WOODY #146

There is a fine line between cockiness and confidence -- which side of the line are you on?

[Scoop 0]

You can copy & paste an excel spreadsheet into a word document although I'm sure there is a more complicated method as well

[woodpecker 0]

doesnt work. I have a spreadsheet with three pages tab'd so it doesnt work out well. cuts it all to shit

SONIC WOODY #146

There is a fine line between cockiness and confidence -- which side of the line are you on?

[jcd11235 0]

In the menu bar, click on:

Insert --> File

Choose your file.


(This was done with Office 2004. I don't know if 2003 version works exactly the same way.)

Math tutoring available. Only $6! per hour! First lesson: Factorials!

[Scoop 0]

I found this on some college website

Quote

How to insert a Microsoft Excel spreadsheet into Word:

Place your cursor where you want to insert the spreadsheet.
Click on “Insert” at the top of the document in the taskbar.
Scroll down the list and click on “File.”
The “Insert File” box will pop up asking you which file you want to attach. Choose the drive where your Microsoft Excel document is located and double-click on the document name.
The “Convert File” box will then pop up. Make sure that “Microsoft Excel Worksheet” is highlighted. Click “OK.”
Next, the “Open Worksheet” box will pop up.
• Here you must select “Entire Workbook,” “Sheet 1,” “Sheet 2,” or “Sheet 3” depending on what part of the spreadsheet/work book you want to insert.
• If you choose one specific sheet, you must then specify “Name or Cell Range.” You can select “Entire Worksheet” or type in a specific cell range.
• Click “OK.”
The document is then inserted into your Word document.

[BIGUN 1,488]

Or, if you're sending it softcopy, you can always embed it in the document as an object:

Insert
Object
Create from File Tab
Browse
Display as Icon (change the icon name to remove the path statement)
When they receive it, they click on the icon and it spawns the excel spreadsheet which they can then "Save as..."

Nobody has time to listen; because they're desperately chasing the need of being heard.

[Squeak 17]

or click on the insert spreadsheet icon from the toolbar

You are not now, nor will you ever be, good enough to not die in this sport (Sparky)
My Life ROCKS!
How's yours doing?

[BIGUN 1,488]

Yup, that'll insert an excel worksheet... but I don't think it inserts an existing file.

Nobody has time to listen; because they're desperately chasing the need of being heard.

[4201 0]

Create an embedded object from an existing Microsoft Excel worksheet or chart
Open both the Word document and the Microsoft Excel workbook that contains the data you want to create an embedded object from.


Switch to Microsoft Excel, and then select the entire worksheet, a range of cells, or the chart you want.


Click Copy .


Switch to the Word document, and then click where you want to insert the embedded object.


On the Edit menu, click Paste Special.


Click Paste.


In the As box, click Microsoft Excel Worksheet Object or Microsoft Excel Chart Object.


To display the embedded worksheet or chart as an icon, select the Display as icon check box.
Notes

For a quick way to create an embedded object from an entire worksheet, click Object on the Insert menu, and then click the Create from File tab. In the File name box, type the name of the workbook you want to create an embedded object from, or click Browse to select a file name from a list. Clear the Link to file check box. If you want, select or clear the Display as icon check box.


Whether you use the Paste Special command or the Insert Object command to create an embedded Microsoft Excel object, Word actually inserts the entire workbook into your document. (If you use the Paste Special command, the embedded object displays just the worksheet data you selected; if you use the Insert Object command, the embedded object displays the first page in the workbook.) In either case, you can display only one worksheet in the workbook at a time. To display a different worksheet, double-click the embedded object, and then click a different worksheet.

[4201 0]

Hope this helps