How to Insert Spreadsheet and Database Tables From Microsoft Applications

   
Intoduction  

Tables from Windows-based spreadsheets (like Microsoft Excel, etc.) and Windows-based databases (like Microsoft Access, etc.) can be inserted directly into your document by using the following procedure.

   
Step
Action
1 Select (highlight) the table area.
2 Select Edit/Copy from the menu bar.
3 Select Edit/Paste (or Paste Cells) from the menu bar.
4 Type the table title into the document.
Note: The table title will go above the table.
5 Click on Table Title in the format toolbar to format the table title and insert the autonumber.
Important: Be sure to have Use Auto Numbering to Number Figures and Tables selected in the Format Assistant dialog box.
   
Oversized tables: landscape or as pictures  

Severely oversized tables may fit best with landscape orientation or be inserted into your document as graphics, rather than text-based tables. These graphics can then be resized/reduced to fit the space available on one page.

We would like to avoid this whenever possible since the table pasted as a picture cannot be formatted to SEMATECH style standards. It also cannot be edited since it is a picture and not table text.

   

Back | Next | Table of Contents

Maintained by Debra Elley.