A Calculating Trick! Insert an Excel Spreadsheet into MS Word

19/12/2018 by Billy Lemmtec

Have you ever inserted a simple table in a Word document, only to enter numeric values and manually manipulate data? Or have you opened a separate spreadsheet only to re-key or copy the results into the table in your document? Do you ever struggle with column alignment or other formatting within Word? And how do you deal with the misaligned results when you paste the values from a spreadsheet into a Word document?

Did you know you can insert a functional Excel spreadsheet directly into your Word document? You can even apply formatting, colors, and titles, and enter advanced formulas directly into the Word document!

Here’s how:

1. Click on the insert menu and table item on the Word Ribbon and select Excel Spreadsheet.
   • A spreadsheet will appear within your document
2. Proceed to enter values and formulas as you would in Excel
3. The Excel Ribbon and menu items appear when you double-click within the spreadsheet. You can format the rows, columns, and values as you would normally in Excel
4. The non-printed cell borders still appear in the document as you continue to work
5. When you print the document to a pdf or printer the formatted rows, cells, and columns appear perfectly

Your work just got easier!