Place the cursor where you want to paste the data.

Then press CTRL+C to copy the Excel data.

First of all, select the data in Excel workbook.

This is the quickest way to show Excel data in Word without losing format. Our goal is to copy and paste it into a Word file while keeping the format intact. We have a dataset in table format in an Excel worksheet. Note: For text links, If you choose the Clear Text Formatting option on the edit toolbar of a destination link, it will only clear the formatting applied at the destination and not formatting that flows from the source.4 Effective Methods to Copy from Excel to Word Without Losing Formatting If you have flow-through formatting from the source, you can also customize each of your destination links.Īny changes made in the destination link (font, size, bold, etc.) overrides the flow-through formatting from the source. Note: Paragraph formatting only flows-through from the source if the destination includes the first character of the paragraph from the source.

Once checked, formatting such as bold, italic, font family, and text color, and paragraph settings flows-through from the source link to all destination links.

Click the Use link formatting from source box.

This opens up the Link Formatting Panel located on the right.Right-click on the destination link and select Link Formatting.Value formats, such as accounting, do not flow through to cell destination links. įor cell links, the source formatting, such as text and paragraph formatting, flows-through from the source link to all destination links. Right-click on destination link and select Cell Properties.From the Cell Properties panel, scroll down to Advanced Options.Right-click on the source link and select Cell Properties.Cell linksįor flow-through formatting in a cell, you must first select Include link formatting at the source.

Once a change to a source link is published, that change automatically flows to your destination links once the Use Link Formatting from Source box is checked at the destination. You can also change formatting at a destination. The formatting from a source link will flow-through to your destination links.

Source formatting in word