excel training program - Add an Excel file to a word document

Resolved · Low Priority · Version Standard

Tue 28 Nov 2006, 14:32 Delegate Jenny said...

Jenny has attended:
PowerPoint Intermediate Advanced course

Add an Excel file to a word document

When I try and add an excel file to a word document (Insert/file) the excel file appears to be corrupted.
Is there a way around this/am I saving the file in the wrond format? Or should I just stick with copy and paste?

Many thanks

Jen

Tue 28 Nov 2006, 14:37 Edited on Thu 30 Nov 2006, 16:57 Trainer Meenesh said...

RE: Add an Excel file to a word document

Try inserting the spreasheet as an object, so click on Insert and then object and then create from file tab. Select the file.
Did this work?

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Fill formulae across a sheet

To copy a formula down a spreadsheet where there is data underneath, to the left or to the right of the formula, double-click on the fill handle. The fill handle is the little black cross that appears in the bottom right-hand corner of the formula cell. Unfortunately, no similar facility exists to copy formulae across the sheet.

One reasonably quick way to copy an existing formula across a sheet is to select the formula and the cells on the right to which you want to copy it. Then press Ctrl+R to copy the formula across the selected range, or, if you are menu-minded, use the Edit|Fill|Right command.

View all Excel hints and tips