10.2

The Table Link dialog box
4
Click Browse to locate and select an Excel file to import.
5
If the file includes multiple worksheets, choose the one you want to import from the
Sheet drop-down menu. If you want to import only a portion of the data, you can
specify a cell range in the Range field or choose a named range from the drop-down
menu.
6
In the Options area, check the attributes you want to import.
7
Click OK.
Formulas and references are not imported. Instead, the final values that result from
formulas and references are imported. Inserted pictures are not imported. Text with
Auto Filter or Advance Filter (Data > Filter) applied is imported as static text.
A quicker way to create a table from Excel data — without linking the source table to
the QuarkXPress project for updates — is to copy and paste. To do this, select any
portion of data in an Excel worksheet and copy the selected data. Then simply switch
to QuarkXPress and choose Edit > Paste. QuarkXPress creates a table appropriate to
the data and inserts the text.
Importing Excel charts
If you have charts or pictures created using Insert > Chart or Insert > Picture in Excel
that you want to use in a QuarkXPress layout, you can import those charts or pictures
the same way you import other pictures. To do this, use the Insert Chart tab of the
Import Picture dialog box (File menu). Charts and pictures imported from Excel are
tracked by the Pictures tab of the Usage dialog box (Utilities menu) just like other
pictures.
A GUIDE TO QUARKXPRESS 10.2 | 85
BOXES, LINES, AND TABLES