Problem: My co-worker is working on a report in Word. I need to add a table and chart to Word. I hate Word.
- If you have to work in Word, it is better to have Excel.
Strategy: You can use the full power of Excel in Word. While you are typing the document, you can put all of the Excel ribbon tabs in the Word ribbon. Follow these steps:
- Place the insertion point where the table should start.
- Select Insert, Object. Word will display the Object dialog box.
- Choose Microsoft Excel Worksheet. Click OK. You now have Excel ribbon tabs at the top of Word!
- Build your worksheet in the frame. You can use the resize handles in the corner of the frame to make the worksheet as wide and tall as necessary.
- Consider using View, Show, and uncheck Gridlines. This will hide the gridlines when the worksheet is embedded in Word.
- Click outside the spreadsheet frame. The worksheet appears in Word.
Additional Details: It seems bizarre, but if you need to put a Word paragraph in Excel, you can use the same trick in Excel. Choose Insert, Object, Microsoft Word.