10.2

3
If you want to create text cells that expand as you add text, use the controls in the
Auto Fit area.
4
If you want the information in the table to flow differently — for example, if the values
are currently in descending order but would have more impact in ascending order —
you can change the flow. Choose an option from the Cell Fill Order drop-down menu
(the default is Left to Right, Top Down).
5
Click OK. A new table is created, offset from the original text box.
Importing Excel tables
Table data often originates in a spreadsheet program such as Excel, and you can import
table data just as you import pictures. Although the technique is slightly different, the
results are the same: The table in QuarkXPress is linked to the Excel file for tracking
and updating.
You can import both .xls and .xlsx files.
If you import a table from Excel using the Link to External Table feature in the Table
Properties dialog box, table usage will be tracked just as picture usage is tracked. This
ensures that you're notified if the source table changes, and that you have the latest
table data when you output the layout, whether you print, collect for output, save as
a PDF, or export to HTML. To check the status of a table, choose Utilities > Usage,
and then click the Tables tab.
Although you can update tables just as you can update pictures, you'll need to keep
the following points in mind:
• If you check Include Formats in the Table Link dialog box when you first import an
Excel table, the table's Excel formatting is preserved (as much as possible) in
QuarkXPress. If you later update the table, any local formatting you have applied in
QuarkXPress is removed and replaced with the formatting from the Excel file.
• If you do not check Include Formats in the Table Link dialog box when you first
import an Excel table, the table's Excel formatting is discarded. If you later update the
table, QuarkXPress attempts to preserve any local formatting you have applied to the
table in QuarkXPress.
To import an Excel table and maintain the link in QuarkXPress:
1
Using the Tables tool, drag to draw a table of approximately the dimensions you need.
The Table Properties dialog box displays when you release the mouse button.
2
Check Link to External Data.
3
Click OK to display the Table Link dialog box.
84 | A GUIDE TO QUARKXPRESS 10.2
BOXES, LINES, AND TABLES