Create Excel spreadsheets directly in Word
December 1, 2022
Flipping back and forth between Excel and Word to insert tables into Word documents is the kind of manual and time-consuming work that we suggest you stop doing. There is no need to retype the content, figure by figure, or to try to make accurate screen shots of your tables. You can access the Excel spreadsheet, with all its smart features, directly in Word.
Try creating a table directly in Word
Inserting an Excel spreadsheet in your Word document
1. click on Insert
2. click on Table
3. Click on Excel spreadsheet
Use multiple sheets - to see both calculations and results
1. Click on the plus sign in the lower part of the Excel worksheet, to the right of Sheet 1.
2. Select the chart you wish to use
Remove the cells' gridlines - for better visualization
1. Select your entire spreadsheet by clicking on the arrow in the top left corner.
2. Click on the color icon
3. Click on the same color as the background, usually white.
Do you prefer to work directly in Excel?
If you prefer to work in Excel and have the Word document updated automatically, our product Excel2Word may be for you.
With Excel2Word you can create charts in Excel and link them to your report in Word at the click of a button. When you change your data in Excel - the chart changes in Word.