2022

A Guide to QuarkXPress 2022 | 168
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
content to tables much as you add content to boxes — by typing text, importing
text, or importing pictures.
Converting text cells to picture cells is the same as converting a text box to a 
picture box. Select all the cells you want to convert and choose Item >
Content > Picture.
Editing table text
Two important things to know about editing text within tables are how to
navigate between cells and how to select text for formatting. As always when
working with text, you must first select the Text Content tool .
Navigating through a table works as follows:
Click in a cell in which you want to enter or import text. ●
Press Tab to move to the next cell. ●