Print to file

[Linda]

Hello Everyone,

Using Excel 2000 SP-1. We have 3 printers we use. A Lanier laser
multifunction copy/printer, HP Office Jet, and HP 4000 Laser. When we print
our spreadsheet, it prints fine on the two laser printers. When we print it
on the office jet, the last row is printed on a second page. If we check
the box "print to file", how does that work? In help this is what I found.

If you print a workbook to a file so that you can later print the file on a
different type of printer than the one used to create the document, the page
breaks and font spacing may change.



Is there a way to save the file without having to change the formatting
everytime you use a different printer?



Thanks,

Linda

 

[Jordon]

Using Excel 2000 SP-1. We have 3 printers we use. A Lanier laser
multifunction copy/printer, HP Office Jet, and HP 4000 Laser. When we print
our spreadsheet, it prints fine on the two laser printers. When we print it
on the office jet, the last row is printed on a second page.

How about changing the page setup to print in on one page?

Jordon

 

[Earl Kiosterud]

Linda,

The first thing to check is the print driver for the offending printer. Go
to the printer manufacturer's web site, and download and install the latest
print drivers. Print drivers are notoriously buggy, and may never be fully
operational when the sun eventually expands and burns up the earth.

If the row that's being printed on the second page is at the bottom of the
page, you may be on the edge, so to speak, with your margins. Try moving
the bottom margin down just a smidge (or the top margin up).

 

[Tom Ogilvy]

Try selecting Fit to one page wide and one page tall in the page setup.

Printing to a file saves control codes specific to that printer, so copying
the file to another printer would probably not be a solution.

 

[Linda]

print

How about changing the page setup to print in on one page?

Jordon

One of the problems with that is there are a few sheets that have 2 or 3
pages intentionally. I guess I have to do each sheet seperately?

Thanks,
Linda

 

[Earl Kiosterud]

Tom,

Printing to a file saves control codes
specific to that printer...

That's what I thought, but the help specifically mentions being able to
redirect to a different printer, as Linda said. Hmmm. I've always thought
that the very data stream (printer-specific, that is) that the print driver
would send to the printer was instead written to a file, to be copied
directly to a similar printer later -- not a different kind of printer.

I tried it once. Getting angry before trying do print tasks in Windows apps
saves time. No joy. It printed part of the document.