#KEEP SOURCE FORMATTING WORD ON MAC HOW TO#
#KEEP SOURCE FORMATTING WORD ON MAC SOFTWARE#
#KEEP SOURCE FORMATTING WORD ON MAC CODE#

Remove the spaces and the row heights are fixed. With Show All, it’s easy to see that the row height problem is caused by excess spaces in the Sales cells. That will reveal the exact characters in each cell.

#KEEP SOURCE FORMATTING WORD ON MAC HOW TO#

How to fix the formatting errors after pasting? It depends on what mistakes Word has made (they vary) but here’s some tips and examples.

#KEEP SOURCE FORMATTING WORD ON MAC CODE#

If you’re interested, all this is done via a LINK field code (press Alt + F9 to reveal codes) Just one example, we’ve changed the text color and enlarged the text in a single row. You can also change formatting of individual rows, columns or cells. Use the Table | Design tab to totally change the look, regardless of your initial Paste selection. The important point is that it’s a Word table – you can format it like any other Word table. That’s why they are in grey when editing the table to indicate they are linked data. Each Excel cell is inserted into a corresponding table cell. It’s a normal Word table with the Table Tools available on the ribbon. In the pasted data above, Word has created a table. If you understand what Office has done, you’ll be more confident in making changes. Under the hoodĪ little digression to discuss what’s happened in the Paste Link. You’ll need to fix those formatting problems but happily it’s pretty easy. This happens almost inevitably when Paste Linking a worksheet. The top line is wrapped across two lines and each data row height is wrong. See the pasted table and compare it with the Excel worksheet shown above? The formatting is all wrong. When you paste a worksheet into Word, there’s usually problems with the result. In Microsoft’s world, worksheets are pasted in perfectly and work first time. In official lessons about this feature, that’s as far as you’ll be shown. But first lets see how linked worksheets appear in the real world. We’ll look at updating options for the worksheet a little later. As you’ll see, it’s easy to change the look of the table. Link and Use Destination Styles – uses the default table formatting of the document.Ĭhoose whichever closest suits your needs. Link and Keep Source Formatting – the worksheet segment appears with the look of the original worksheet. Two of the Paste options are will link the worksheet to the document (look for the little chain icon – chain … link. There are a few more options than you normally see. Then switch to Word and choose Paste from the Home menu. Copy and Paste Specialįirstly, select the worksheet section that you want in the document and Copy it to the clipboard. There are others but this is the simplest and (mostly) easiest to work with.

In this article we’re going to focus on the primary method for dynamic or linked worksheets. Any changes to the worksheet will appear in the linked Word document too.

a fixed, one-time copy or snapshot of the Excel worksheet.

There are two broad options for linking a worksheet into a document: If you gave up on embedding worksheets as a bad joke, here’s an opportunity to try again.

#KEEP SOURCE FORMATTING WORD ON MAC SOFTWARE#

These days the software and hardware is a lot better. If embedding worked at all, it was often very slow or unstable. It worked great in Microsoft’s carefully rehearsed demos but not so much in the real world. Linking a worksheet into Word took up a lot of resources. All manner of different options were available with plenty of acronyms thrown in to either impress an audience or confuse them. There was a time when Microsoft could not stop demonstrating embedding Excel documents into Word. This is possible in Microsoft Office it’s been available for many years. The cool thing is that Word actively links into the worksheet, meaning whenever the worksheet changes, so will the document. It’s really an Excel worksheet linked into the Word document. This looks like a standard Word table and it can be formatted like a table … but it’s a special kind of table. You have a table or chart in Excel … you get that into Word in several ways but there are traps that Microsoft doesn’t mention in their help.

Keep source formatting word on mac