Sommaire

Copying data from Excel to Word

When you copy data from an Excel spreadsheet into a Word document a Paste Options images/13i37.png button appears: point to the Paste Options images/13i37.png button that appears just below the pasted items, then open the associated list and click one of the options.

images/3013rb01.png
images/13i38.png

Keeps the formatting applied to the Excel cells (such as borders and width).

images/13i140.png

Displays the pasted data in a Word table; the formatting applied to the Excel cells is lost.

images/13i141.png

To keep the original formatting of the Excel cells and create a link; all changes (formatting or data) made to the source data in Excel are instantly applied to the linked data in Word.

images/13i142.png

Displays the pasted data in a Word table; then creates a link with the Excel table.

images/13i143.png

The data is inserted as an image; there is no link between the data source (Excel) and the image inserted in the Word document.

images/13i144.png

Only the text is kept: each item of data is separated by a tab.

The images/13i141.png and images/13i142.png tools are not available when you use the Office Clipboard to paste data from Excel into Word.

When you copy an Excel chart into Word, the Paste Options tool button images/13i37.png gives you the following options: 

images/13i145.png

The colours and fonts of the theme associated with the document are applied; the chart formatting applied in Excel is not preserved.

images/13i146.png

The chart is inserted as an embedded object which means unlinked. The formatting applied to the Excel chart is kept.

images/13i149.png

The chart is inserted as a linked object; all changes made to the object in Excel will be immediately reflected in Word. The colours and fonts of the theme associated with the document are applied to the chart. The formatting ...