PLANET QUARK

by Quark users for Quark users

Tag: tables

QuarkXPress 10 Keeps Formatting when Updating Excel Tables

November 18, 2013November 18, 2013How-to, TipNo Comments

One of the new features in QuarkXPress 10 is that tables imported from Excel and formatted in QuarkXPress can now maintain the QuarkXPress formatting when the Excel table is updated.

The trick is to NOT include any of the Excel formatting when you first import the table — you can include the geometry, but then format the table in XPress.

To create a table in QuarkXPress and link an Excel spreadsheet to it, first get the Table tool:

Table Tool

Click and drag on the page to define an area for the table. Here’s what the first dialog box looks like after you do that:

Table Properties dialog-Link to external

When you check the “Link to External Data” checkbox and click the OK button, this dialog appears:

Table Link-no properties

Note that the “Include Style Sheets” and  “Include Formats” checkboxes are not checked. Browse to your Excel table and click the OK button to import it into the table on the QuarkXPress page.

When the original Excel table is changed, you can successfully update the table in QuarkXPress by choosing Utilities> Usage…

Usage>Tables>UpdateCookedBooks

… and your existing QuarkXPress formatting will still apply to the updated table!

Jay Nelson

Jay Nelson is the editorial director of PlanetQuark.com, and the editor and publisher of Design Tools Monthly. He’s also the author of the QuarkXPress 8 and QuarkXPress 7 training titles at Lynda.com, as well as the training videos Quark includes in the box with QuarkXPress 7 . In addition, Jay writes regularly for Macworld and Photoshop User magazines and speaks at industry events.

http://www.design-tools.com

Tips for Resizing Columns and Rows in Tables in QuarkXPress

March 13, 2012March 12, 2012Tip2 Comments

When you change the width of a column in a table in QuarkXPress, one of two things happen: either the entire table changes width to accommodate the new column width, or the table stays the same width while the other columns adapt to the change.

To resize one column or row while maintaining the widths of the other columns and rows (but changing the width of the entire table), just use the Content (hand) tool to drag the line that separates it from other columns or rows:

To maintain the size of the table, but force the other columns to adapt to the column you’re changing, first go to Item> Modify (Command-M/Ctrl-M), choose the Table tab, and turn on the Maintain Geometry checkbox. This tells XPress not to change the size of the table when you change the size of its cells:

Jay Nelson

Jay Nelson is the editorial director of PlanetQuark.com, and the editor and publisher of Design Tools Monthly. He’s also the author of the QuarkXPress 8 and QuarkXPress 7 training titles at Lynda.com, as well as the training videos Quark includes in the box with QuarkXPress 7 . In addition, Jay writes regularly for Macworld and Photoshop User magazines and speaks at industry events.

http://www.design-tools.com

Unlink an Excel Table in QuarkXPress

July 12, 2010July 12, 2010Learn, Tip1 Comment

I have a table that I imported from Excel, and since I have made many changes to this table in QuarkXPress I do not want it to be linked to the Excel file any longer. Is there some way to unlink this table?

The answer is simple, if not obvious:

To break the link with the original Excel file, choose Table> Convert Table> To Group. (You can also right-click or Control-click on the table, and choose the same thing.) The table will keep its formatting, but no longer be linked to the original Excel file.

Jay Nelson

Jay Nelson is the editorial director of PlanetQuark.com, and the editor and publisher of Design Tools Monthly. He’s also the author of the QuarkXPress 8 and QuarkXPress 7 training titles at Lynda.com, as well as the training videos Quark includes in the box with QuarkXPress 7 . In addition, Jay writes regularly for Macworld and Photoshop User magazines and speaks at industry events.

http://www.design-tools.com

Use Excel Tables in QuarkXPress

March 24, 2010Learn, Tip15 Comments

In QuarkXPress 6.1 and above, you can import a spreadsheet from Microsoft Excel as a table, optionally maintaining the formatting from the spreadsheet.

The table keeps a dynamic link to the original Excel spreadsheet, so when the spreadsheet changes, you can instantly update the data in the QuarkXPress table. To update the table, or to see if the Excel spreadsheet has changed, choose Utilities> Usage and click the Tables tab.

Warning: if you have applied any formatting to your table in QuarkXPress, it will be lost when you update it with new Excel data, so you’ll probably want to use the spreadsheet as-is.

Tip: when first importing an Excel spreadsheet, leave the Include Formats and Include Geometry options unchecked. Some spreadsheets are enormous, so it’s best to see how big it is first.

Jay Nelson

Jay Nelson is the editorial director of PlanetQuark.com, and the editor and publisher of Design Tools Monthly. He’s also the author of the QuarkXPress 8 and QuarkXPress 7 training titles at Lynda.com, as well as the training videos Quark includes in the box with QuarkXPress 7 . In addition, Jay writes regularly for Macworld and Photoshop User magazines and speaks at industry events.

http://www.design-tools.com

Another FREE XTension from Quark: XPressMath creates professional mathematical equations

December 2, 2009December 2, 2009News, Quark, XTensions3 Comments

Quark has released a FREE XTension for QuarkXPress 8 that lets you typeset complex mathematical formulas and equations directly in QuarkXPress. In addition to providing a relatively simple interface for building the equations, you can edit existing equations in a WYSIWYG window. You can also use a style-sheet-like system to ensure that all equations in a project share a similar appearance.

Here is Quark’s list of the features in XPressMath:

  • Associate characters with procedures (such as Sigma with summation)
  • Typeset horizontal and vertical placement
  • Insert fixed integrals, radicals, and summations
  • Customise space around mathematical structures
  • Import and export ASCII text for offline keyboarding
  • Edit in WYSIWYG view to easily format previously created mathematic equations and structures
  • Perform advanced formatting in the Equation Builder window
  • Export an equation in JPEG format (replaces PICT [Mac] and BMP [Windows] export)
  • Support Unicode
  • Access four additional pi character levels

XPressMath formerly cost $259 for earlier versions of QuarkXPress, but now it’s free!

Jay Nelson

Jay Nelson is the editorial director of PlanetQuark.com, and the editor and publisher of Design Tools Monthly. He’s also the author of the QuarkXPress 8 and QuarkXPress 7 training titles at Lynda.com, as well as the training videos Quark includes in the box with QuarkXPress 7 . In addition, Jay writes regularly for Macworld and Photoshop User magazines and speaks at industry events.

http://www.design-tools.com

Posts navigation

1 2 3

Search this site

How to quickly convert PDF to editable objects:

Categories

Sponsored

The five most helpful posts

The Non-Rental Suite for Creative Pro’s

How to delete preferences in QuarkXPress

How to test Mojave (10.14) – and how to revert to your previous version of MacOS

IDML import in use: why this is huge

Where is the free QuarkXPress Document Converter?

 

Recent News

  • Since October 18, 2018, QuarkXPress is available in the Mac App Store. It's called "QuarkXPress 2018 Pro". Read about the differences to QuarkXPress and what features it offers.Read more
  • QuarkXPress 2018 October Update adds a "dark theme" on MacOS to seamlessly integrate with Mojave's Dark Mode.Read more
  • Quark Software announced on September 17th a new software bundle offer that will save designers Read more
  • The (free) QuarkXPress 2018 October Update will add Mojave support and adds an "auto fit image" feature. Additionally you can "fill", so fill a box with an image. Both can be done manually (command key) or automatically, so even when you resize the box.Read more
  • Design on your iPad wherever you are with DesignPad, the iPad app that puts grid-based design control in the palm of your hand. No need to own InDesign or QuarkXPress. New 2018 version available now!Read more
  • Automatic hyphenation is an important tool to help you make text look good. See how QuarkXPress 2018 can help you create even better hyphenation with the new strictness level. Of course available for many languages, like Dutch, English, French, German, Italian, Spanish and more.Read more
  • Due to popular demand, the first update for QuarkXPress 2018 adds back the font sub menus on MacOS. The free update further adds new JavaScript methods and further improves stability, quality and performance.Read more

Most popular posts this week

  • How to discover the UDID of an iPad without having iTunes 56.33 views per day
  • See Everything Your Mac Printed 26.67 views per day
  • Where is the free QuarkXPress Document Converter? 11.67 views per day
  • 132 ppi? 72 dpi? 144? 264 ppi? What image resolution should you use for the new iPad with Retina display? 10.50 views per day
  • How to delete preferences in QuarkXPress 10.33 views per day
  • The Correct Use of Apostrophes in Dates 10.17 views per day
  • Batch-Convert Illustrator to PDF 9.17 views per day

Tags

Apple App Studio AVE Publishing Bootable Backup Business models color Digital Publishing eBooks El Capitan ePub exporting Flash Font html HTML5 HTML5 Publications images integration iPad iphone JavaScript layout long docs macOS OS X PDF printing QID Quark QuarkXPress QuarkXPress 7 QuarkXPress 8 QuarkXPress 9 QuarkXPress 10 QuarkXPress 2015 QuarkXPress 2016 QuarkXPress 2017 QuarkXPress 2018 Review Self Publishing tables text Tip Typography Video Tutorial
Proudly powered by WordPress | Theme: Doo by ThemeVS.
This website uses cookies to improve your experience on our website. By continuing to browse this site you are agreeing to our use of cookies. You can disable cookies in your browser settings at any time.Accept CookiePrivacy Policy