Printing Spreadsheet to Plotter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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.
 
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)
 
Back
Top