2018

BOXES, LINES, AND TABLES
A Guide to QuarkXPress 2018 | 121
The Table Link dialog box
Click Browse to locate and select an Excel file to import.4.
If the file includes multiple worksheets, choose the one you want to import5.
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.
In the Options area, check the attributes you want to import.
6.
Click OK.7.
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