hostbucket.blogg.se - Copy table formatting in word 2010

Copy table formatting in word 2010 how to#
Copy table formatting in word 2010 update#

If you’re preparing a report and all you want is a really easy way to show some table (without any need to change the data), you can insert that data as an image.ĭoing this is really easy and images are also easier to manage in Word (such as placement and resizing). On the downside, if you use multiple such tables or if the data is large, it will lead to a heavy Word document (as it has to also bear the weight of the embedded Excel file). So, if you save the Word file or share it with someone else, the Excel file would remain with it and the data would remain intact. Unlike the previous method, in this method, the Excel file is a part of the Word document. The biggest benefit of using this method is that you don’t have to worry about two separate files. Also, any formulas you have in place would continue to work. You can make any change and also use functionality such as conditional formatting, and that would be reflected in the table. Suppose you have a table in Excel as shown below that you want to copy to Word. In layman terms, it’s as if you can open and work on an Excel worksheet from within the Word Document.

Copy table formatting in word 2010 how to#

In this section, I will show you how to embed the Excel file within the Word document, so you won’t have to keep both the files (and only keep the Word file). In the above method, I showed you how to keep the Excel and Word files together and keep them linked. It allows you to embed an Excel document as a part of the Word document. This is a really useful feature that MS Word offers.

Copy table formatting in word 2010 update#

By using this method, you can only copy a small part of the Excel file, while still being able to update the table when values change in Excel. This method is best suited for situations where you have a large Excel file that has a lot of calculations/data/ dashboards. This works even if the Excel file is closed.

Whenever the Word file opens, it will check for any updates in the Excel table.

If you’re sending the Word file to someone, you will also have to send them the Excel file, or the link would be broken and the data in Word would not update.

Since the two files are linked to each other, you will have to keep these together.

Here are some things you need to know about this method: If for some reason your data doesn’t update in real-time, right-click on the table and click on the ‘Update Link’ option Now, if you go and make any changes in the table in Excel, you will see that the same is reflected in the table in Word (in real-time). The above steps would insert the copied table in Word, where it’s still linked to the original table in Excel. Suppose you have a table as shown below and you want to copy it from Excel to MS Word and keep this linked. By having the linked table, you only need to make changes in Excel data and these would automatically get reflected in the table you copied to Word. This is quite useful when there is a possibility that you may have to update the data in Excel and it would also need to be updated in Word.

This way, if you make any changes in the Excel table that you copied, you will see that these are reflected in real-time in the table in Word as well. In the above method, we copied the data from Excel and inserted it as a static table into Word.Īnother option that you can use is to copy and paste the table into a Word document and keep the two tables linked. It shows up when you click on the Paste Options icon after you have pasted the table in Word.Įmbed Excel Table into Word (as a Linked Object) If you don’t want to get copy the formatting from Excel and would rather want to use the formatting of the Word document, you can use the option Use Destination Style option.

If you make any changes to any data, you will have to manually adjust the formula values as well In my example, I have the formulas in the Total row, but when copied to Word, these are static values.

If there are any formulas in the table in Excel, they won’t be copied.

Once you have the table in Word, you can format and work with it just like any other table that you insert in Word.Ī couple of things to note when using this method: The above steps would copy the data from Excel and paste it as a static table in the Word document.