2023

User Guide | 173
If the file includes multiple worksheets, choose the one you want to import 5
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.
You can select to include the text and table formatting already included in 6
the source document (“Options > Include Formats“), and the column widths /
row heights (“Options > Include Geometry“). You can also choose whether to
hide or show any rows or columns that are hidden in the source Worksheet.
You can specify how many rows of the table should be considered header 7
rows (“Header Rows“), whether the box will expand to fit the table (default) or
whether the table will be resized to fit the box (“Fit to Box“), and which table
style to apply.
You can choose to import a Table along with its style from MS Excel. Simply 8
select the “Table Style“ drop down to be “Inherit“ and import.
You can also choose to apply either a preset Table style or a custom created 9
Table style from the “Table Style“ drop down on the imported Excel data.
Click OK. 10
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.
Adding text and pictures to tables
When working with tables, think of a table cell as a text box or a picture box.
Each box contains content — text that may or may not be linked to the next cell,
an individual picture, or nothing (maybe just a gradient). Therefore, you can add