Today’s tip is about using Excel in MS Word. Of course you can copy and paste an existing spreadsheet into a Word document, but you can also create a spreadsheet from scratch. As you may know Word tables don’t do calculations, so if you need to do calculations and you want the numbers to format correctly, insert an Excel “object.”
1. In Word, click the Insert tab.
2. Click on “Object”
3. A menu box will open from which you will choose one of the Excel options. I selected the 2007, Binary workbook.
4. Up pops an edit-ready worksheet, like this:
When you click outside the table, it looks like this and cannot be modified as long as it looks this way:
Have fun with that!
Thanks for stopping by!