PageMaker for Desktop Publishers
Portrait of Aldus Manutius   PAGEMAKR: PageMaker for Desktop Publishers
Easy Access:  
Search Net Search PAGEMAKR web site
PAGEMAKR List
decorative dotHome
decorative dotWelcome!
decorative dotSubscription Help
decorative dotPageMaker FAQ
decorative dotList Archives
decorative dotPM Scripting
decorative dotSubscriber Pages
decorative dotDTP Humor

Special Interest
decorative dotDamaged PM Docs
decorative dotPM Color Mgmt
decorative dotPageMaker History
decorative dotLearning PageMaker
decorative dotMonthly Essays
decorative dotThe Euro
decorative dotViruses & PM

Desktop Publishing
decorative dotGlossary
decorative dotTips & Tricks
decorative dotType & Typography
decorative dotBooks
decorative dotClip Art
decorative dotUtilities & Plug-Ins
decorative dotDownloads

PageMaker at Adobe
decorative dotAdobe PageMaker
decorative dotTech Support
decorative dotUpdates
decorative dotTechnical Docs
decorative dotFeature Requests
decorative dotAdobe Magazine
decorative dotQ&A Archives
decorative dotUser-to-User Forums

Related Links
decorative dotFormat Newsletter
decorative dotBefore & After
decorative dotInside PageMaker
decorative dotAbout DTP
decorative dotPDF Zone
decorative dotGraphics list
decorative dotAdobe Photoshop
decorative dotPhotoshop list
decorative dotAdobe InDesign
decorative dotInDesign List
decorative dotIllustrator
decorative dotIllustrator list
decorative dotFreehand
decorative dotFreehand list

Listserv et al
decorative dotSearch for a List
decorative dotLiszt search
decorative dotListserv manual

How you can help!

You can donate money to offset the cost of hosting the site with Paypal by clicking the "donate" button above.

About This Site

Maintained by Peter C.S. Adams and Gordon Woolf.

Design philosophy: all information in this web site should be accessible to the intended audience regardless of platform, browser, or size of screen. Graphics are kept to a minimum to reduce download times. If you see a frame or an animated GIF, feel free to flame me mercilessly.

Valid CSS!

This site uses fully compliant cascading style sheets (CSS). Older browsers should display text in their default fonts, while more recent browsers will all display fully formatted text. (However, the styles sheets will look best viewed in Internet Explorer 4.0 or above.) The site also complies with major accessibility standards.

Bobby Approved

Colophon

The base font for this page is Trebuchet MS, a free font from Microsoft designed for on-screen readability at small point sizes. The headlines are 32 pt Times bold italic, combining elegance, classical proportions, and compactness.

The logo is variation on the original logo from Aldus PageMaker and depicts Aldus Manutius, a student of Johannes Gutenberg and inventor of italics. This is to echo the roots of desktop publishing, both in the 1450s and the 1980s. The logo uses Courier from ITC to evoke the feel of metal type and Poetica from Adobe Systems to evoke the era of hand lettering.

Made on a Macintosh using Adobe Photoshop and Macromedia DreamWeaver.

 

Importing Excel spreadsheets into PageMaker

Often you will need to import an Excel file that is too difficult to re-do in PageMaker: there may be borders, or a chart, or complex number formatting, for instance, as in the example below. PageMaker and InDesign come with Excel import filters that work fairly well, importing numeric data, formulas, tables, and formatting, but they lose other features, like graphics and charts, page numbers, superscripting, and some other items. Fortunately, there are other ways of importing that data.

The best way, if you will be outputting to a PostScript printer, is to create an EPS graphic of the page. This EPS can then be placed into PageMaker and output at high resolution to your PostScript printer.

If you have a Mac, you can output directly to EPS from the Print dialog box. See Using Apple's LaserWriter 8 Driver to Create EPS Images for instructions.

On either a Mac operating system a Windows machine, you can save to a PostScript file and import that into Illustrator or Freehand to create the EPS. Note that you do not need a PostScript printer to create this file, just to print it. To create the file, all you need is a PostScript printer driver. If you don't have one installed, check the Adobe web site or your PageMaker installation CD.

On non-PostScript printers, Excel tables saved as EPS will generally be of poor quality, since all that will print will be the screen preview. In this case, you can import the PostScript file into Photoshop instead and rasterize it. Be sure to do this at high resolution, since bitmaps do nor resize as well as vector EPS. The resulting TIFF file will be large but should output well on any printer.

As a last resort, copy the table in Excel, go to PageMaker, and Paste Special. This uses OLE and can produce good results in-house, but may cause you to make enemies if you have to share the file or send it to a service bureau for output. Be sure you keep the source spreadsheet in the same folder as your publication.

All rights reserved. Unless otherwise specified, all contents copyright © 1993– 2014 Peter C.S. Adams
Last modified March 12, 2004

STEPPS -- Stop Tax Exempt Private Property Sprawl -- Framingham