Printing Spreadsheet to Plotter

J

Jeff Duffer

I have a wide spreadsheet with about 300 rows that I want to print on an HP DesignJet 500PS. It prints sort of ok, but it breaks it up into separate pages, repeating the column headers each time. I want to print just one document, with no space or page breaks between, and with just one set of column headers at the top.
 
A

Andy B

Hi

Depending on the printer (which I don't know of), try setting the Fit To One
Page option on the print dialog box.

Andy.

Jeff Duffer said:
I have a wide spreadsheet with about 300 rows that I want to print on an
Click to expand...
HP DesignJet 500PS. It prints sort of ok, but it breaks it up into separate
pages, repeating the column headers each time. I want to print just one
document, with no space or page breaks between, and with just one set of
column headers at the top.
 
J

jaf

Change the size of the page your printing to. (and reset you print area
afterwards)
Pull up the print driver. There should be a cutom paper size available.

media sizes, std.
8.3- to 42-in wide sheets; 24-, 36-, and 42-in rolls

maximum print length
150 ft




--
John
johnf 202 at hotmail dot com


| Thanks for the reply.
|
| I tried that. The plotter doesn't exactly have pages, so in trying to
choose a page size to fit it to, I have been using "ANSI D - 22 x 34 in."
(and that could be part of my problem). Printing to those pages creates
page breaks, but, if I try to fit the entire spreadsheet to that page size,
then it crams my 8 pages into one of those pages and becomes too small to
read.
 
J

Jeff Duffer

That almost worked for me. Maybe I'm missing something

I can set up a custom paper size for the plotter. But when I try to do the same for Excel (because I want to print the entire spreadsheet to one big page), there's only a drop-down box, which does not seem to contain anything like I want: some of the paper type titles don't really let me see what size they are, and I don't want to test each one)
 
Top