2017
Table Of Contents
- Contents
- About this guide
- The user interface
- Tools
- Menus
- Context menus
- Palettes
- Advanced Image Control palette
- Books palette
- Callout Styles palette
- Colors palette
- Conditional Styles palette
- Content palette
- Content Variables palette
- Footnote Styles palette
- Glyphs palette
- Gradients palette
- Grid Styles palette
- Guides palette
- HTML5 Palette
- Hyperlinks palette
- Image Editing palette
- Index palette
- Item Styles palette
- Layers palette
- Lists palette
- Measurements palette
- Measurements palette - Mac OS X
- Measurements palette - Windows
- Page Layout palette
- Profile Information palette
- Redline palette
- Reflow Tagging palette
- Scale palette
- Style Sheets palette
- Table Styles palette
- Text Shading Styles palette
- Tools palette
- Palette groups and palette sets
- Layout controls
- Views and view sets
- Projects and layouts
- Native QuarkXPress objects
- Content variables
- Boxes, lines, and tables
- Understanding items and content
- Understanding handles
- Understanding Bézier shapes
- Drop Shadows
- Item Find/Change
- Working with boxes
- Creating text and picture boxes
- Resizing boxes
- Locking box and picture proportions
- Reshaping boxes
- Adding frames to boxes
- Applying colors to boxes
- Applying gradients to boxes
- Specifying number of columns in text boxes
- Merging and splitting boxes
- Adding text and pictures to boxes
- Changing box type
- Creating a box from a clipping path
- Copying attributes from one box to another
- Super Step and Repeat
- ShapeMaker
- Working with lines
- Manipulating items
- Working with callouts
- Working with tables
- Drawing a table
- Converting text to tables
- Importing Excel tables
- Importing Excel charts
- Inline tables
- Table styles
- Adding text and pictures to tables
- Editing table text
- Linking table cells
- Formatting tables
- Formatting gridlines
- Inserting and deleting rows and columns
- Combining cells
- Manually resizing tables, rows, and columns
- Converting tables back to text
- Working with tables and groups
- Continuing tables in other locations
- Table Import
- Text and typography
- Editing text
- Importing and exporting text
- Finding and changing text
- Working with footnotes and endnotes
- Checking spelling
- Counting words and characters
- Applying character attributes
- Applying paragraph attributes
- Working with text shading
- Format painter
- Controlling kerning
- Controlling hyphenation and justification
- Controlling tracking
- Working with style sheets
- Working with conditional styles
- Bullets and numbering
- Positioning text in text boxes
- Controlling font usage
- Converting text to boxes
- Using text runaround
- Working with text paths
- Creating drop caps
- Creating rules above and below paragraphs
- Using anchored boxes
- Working with OpenType fonts
- Working with the Glyphs palette
- Displaying invisible characters
- Inserting special characters
- Specifying character language
- Using font fallback
- Working with font mapping rules
- Working with design grids
- Working with hanging characters
- Type Tricks
- Hyperlinks
- Creating a destination
- Creating an anchor
- Creating a hyperlink using an existing destination
- Creating a hyperlink from scratch
- Showing links in the Hyperlinks palette
- Formatting hyperlinks
- Editing and deleting destinations
- Editing and deleting anchors
- Editing and deleting hyperlinks
- Navigating using the Hyperlinks palette
- Pictures
- Working with pictures
- Working with clipping paths
- Working with alpha masks
- Working with PSD pictures
- Cross references
- Color, opacity, and drop shadows
- Working with colors
- The Colors palette
- The Colors dialog box
- Creating a color
- Creating gradients
- Editing a color
- Duplicating a color
- Deleting a color
- Adding colors using the color picker tool
- Importing colors from another article or project
- Changing all instances of one color to another color
- Applying color and shade
- Applying color and shade to text
- Applying color and shade to lines
- Applying transparency blend modes
- Working with opacity
- Color management
- Source setups and output setups
- The color management experience for users
- Working with source setups and output setups from a color expert
- Working in a legacy color management environment
- Proofing color on screen (soft proofing)
- Color management for experts
- Creating a source setup
- Creating an output setup
- Managing profiles
- Working with drop shadows
- Working with colors
- Custom Bleeds
- Item Styles
- DejaVu (Windows only)
- Document construction
- Using automatic page numbering
- Creating an automatic text box
- Working with master pages
- Working with layers
- Understanding layers
- Creating layers
- Selecting layers
- Showing and hiding layers
- Determining which layer an item is on
- Deleting layers
- Changing layer options
- Moving items to a different layer
- Copying and pasting items between layers
- Changing the stacking order of layers
- Layers and text runaround
- Duplicating layers
- Merging layers
- Locking items on layers
- Using master pages with layers
- Suppressing printout of layers
- Using PDF layers
- Working with lists
- Working with indexes
- Working with books
- Working with libraries
- Guides Palette
- Scale functionality
- Cloner functionality
- ImageGrid functionality
- Linkster functionality
- Output
- Collaboration and single-sourcing
- Notes
- Redline
- Job Jackets
- Understanding Job Jackets
- Working with Job Jackets
- Working with Job Tickets
- The default Job Jackets file
- Working with Resources: Advanced mode
- Working with Layout Specifications
- Working with Rules and Rule Sets
- Evaluating a layout
- Job Jackets locking
- Printing with JDF output
- Working with multiple languages
- XTensions software
- Preferences
- Understanding preferences
- Application preferences
- Preferences — Application — Display
- Preferences — Application — Color Theme
- Preferences — Application — Key Shortcuts
- Preferences — Application — Input Settings
- Preferences — Application — Font Fallback
- Preferences — Application — Undo
- Preferences — Application — Open and Save
- Preferences — Application — XTensions Manager
- Preferences — Application — Sharing
- Preferences — Application — Fonts
- Preferences — Application — Text Highlighting
- Preferences — Application — East Asian
- Preferences — Application — Dynamic Guides Color
- Preferences — Application — File List
- Preferences — Application — Default Path
- Preferences — Application — Index
- Preferences — Application — Job Jackets
- Preferences — Application — Notes
- Preferences — Application — PDF
- Preferences — Application — Redline
- Preferences — Application — Spell-Check
- Preferences — Application — Tables
- Preferences — Application — Fraction/Price
- Project preferences
- Layout preferences
- Legal notices
- Index
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.
136 | A GUIDE TO QUARKXPRESS 2017
BOXES, LINES, AND TABLES