 |
 |
| About MrExcel |
| Consulting Services |
| Learn Excel Resources |
| Challenge of the Month |
| MrExcel Seminars |
| MrExcel Store |
| Podcast |
| Search |
| Media |
| Contact |
| Home |
 |
The tip in this show is from Learn Excel 97-2007 From MrExcel.
(Click the book for more details) As I mentioned on the show, viewers can download a F R E E copy of this book from leobook.html Watch the segment video:
Sometimes you are working in a Word document and it would be much easier to use Excel for the next section of the document. Perhaps you need a table, a chart, or some quick formulas. Without leaving Word, you can easily replace the Word menus with Excel and use Excel for the next section of the document. Place the cursor in the Word document and choose Insert - Object.
From the dialog, scroll down and choose Microsoft Excel Worksheet. Click OK.
A mini-worksheet appears in Word. The Word menus have been replaced with Excel menus!
Edit your spreadsheet. You have full access to everything in Excel. Here, I even used Tools - Options and turned off gridlines.
Resize the bounding box to include the section of the worksheet that you want to show.
When you click outside of the Excel bounding box, the worksheet becomes embedded in the document. The Word menus return.
This trick is excellent when you are working in Word but just need a little bit of Excel!
I really hope to give away 5 million copies of the book, so please send your co-workers and friends to
leobook.html.
MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.