10.0

Table Of Contents
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 | 87
BOXES, LINES, AND TABLES