Using Excel Worksheets in Word

[ LiB ]

While you are in Microsoft Word, you can create an Excel worksheet in the document. The worksheet is part of and saved as part of the Word file. The process of saving a document created by an outside application inside of another application is called embedding.

Creating an Excel Worksheet from Within Word

The fastest method to insert an Excel worksheet is to use the Toolbar button available in Word.


graphic/16fig01.gif



graphic/16fig02.gif


NOTE

Don't worry too much about the worksheet size. The size you specify is an estimate and Excel will provide access to the same number of cells as in a normal Excel worksheet; 256 columns and 65,536 rows.


graphic/16fig03.gif



graphic/16fig04.gif



graphic/16fig05.gif



graphic/16fig06.gif


NOTE

Double-click anywhere inside the worksheet to reselect it and continue working.

Resizing the Excel Worksheet in Word

Even though when you first inserted the worksheet, you specified the number of rows and columns, Excel still provides access to the full worksheet size. You can continue entering data in additional rows and columns, although the entire worksheet may not be visible in the Word document. You can resize the worksheet to view more cells.

NOTE

When you deselect the worksheet, the table will display only the current cells. If all the data cells are not visible, they will not be displayed in the Word table either.


graphic/16fig07.gif



graphic/16fig08.gif


  • Dragging a corner handle will enlarge or shrink the worksheet in both height and width in proportion to its original size.

  • Dragging a side handle will modify the worksheet width only.

  • Dragging a top or bottom handle will modify the worksheet height only.


graphic/16fig09.gif



graphic/16fig10.gif


[ LiB ]


Microsoft Office Excel 2003 Fast & Easy
Windows XP Registry: A Complete Guide to Customizing and Optimizing Windows XP (Information Technologies Master Series)
ISBN: N/A
EAN: 2147483647
Year: 2002
Pages: 157
Authors: Olga Kokoreva

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net