I'm trying to format an Excel spreadsheet to print; either by selecting the
section I want to print and/or using the view/ page break preview. For
whatever reason it is not alloweing me to reduce the percentage size to fit
on one page --or drag the page borders in the page break preview. The
spreadsheet is columns A through O and rows 1 through 58. Its strange--
here's the error message it gives

This error can appear if you have attempted to print content which cannot
fit on the printable area of the selected printer. Usually this occurs when
you have selected to:
Print to a page size which is not supported by the printer
Change the margins of the page and that range is not supported by either the
printer or the printer driver
Print using a landscape setting and the printer driver is set to portrait
(or the reverse)
Print a set sized object which does not fit into the printable region
The application is set to print to a margin default which exceeds the
printable area of the page (can sometimes happen after changing the default
printer to a different printer)
Print scaling (percentage size to print the final content) is set to a
number below 10%
Printing issues associated with a network printer are best handled by your
local network administrator or support personnel.

It sounds as though it is a print driver problem, not an Excel problem.

If your printer will print reduced pages, reinstalll the print driver.
"Scott" wrote:

I'm trying to format an Excel spreadsheet to print; either by selecting the
section I want to print and/or using the view/ page break preview. For
whatever reason it is not alloweing me to reduce the percentage size to fit
on one page --or drag the page borders in the page break preview. The
spreadsheet is columns A through O and rows 1 through 58. Its strange--
here's the error message it gives

This error can appear if you have attempted to print content which cannot
fit on the printable area of the selected printer. Usually this occurs when
you have selected to:
Print to a page size which is not supported by the printer
Change the margins of the page and that range is not supported by either the
printer or the printer driver
Print using a landscape setting and the printer driver is set to portrait
(or the reverse)
Print a set sized object which does not fit into the printable region
The application is set to print to a margin default which exceeds the
printable area of the page (can sometimes happen after changing the default
printer to a different printer)
Print scaling (percentage size to print the final content) is set to a
number below 10%
Printing issues associated with a network printer are best handled by your
local network administrator or support personnel.

Excel does not show reduced pages onscreen for print preview. I'm at work
and print to various networked printers and no one else is reporting any
problems so I don't think it is the printers.

Probably not describing my issue that well--
Out of the blue this afternoon I cannot correctly format an Excel spreadseeht
for printing. I use Excel daily and consider myself to be a better than
average user but I am at a loss.

I've tried altering the page set-up in several different excel files and am
getting
the same results- the print view will not reduce the size of that to be
printed-- if I try to drag in page break preview nothing happens-- if I try
to reduce or increase the percentage in page setup it still prints the same
areas in the spreadsheet to be printed. I'm dead in the water at this
point--

"bj" wrote:

It sounds as though it is a print driver problem, not an Excel problem.

If your printer will print reduced pages, reinstalll the print driver.
"Scott" wrote:

I'm trying to format an Excel spreadsheet to print; either by selecting the
section I want to print and/or using the view/ page break preview. For
whatever reason it is not alloweing me to reduce the percentage size to fit
on one page --or drag the page borders in the page break preview. The
spreadsheet is columns A through O and rows 1 through 58. Its strange--
here's the error message it gives

This error can appear if you have attempted to print content which cannot
fit on the printable area of the selected printer. Usually this occurs when
you have selected to:
Print to a page size which is not supported by the printer
Change the margins of the page and that range is not supported by either the
printer or the printer driver
Print using a landscape setting and the printer driver is set to portrait
(or the reverse)
Print a set sized object which does not fit into the printable region
The application is set to print to a margin default which exceeds the
printable area of the page (can sometimes happen after changing the default
printer to a different printer)
Print scaling (percentage size to print the final content) is set to a
number below 10%
Printing issues associated with a network printer are best handled by your
local network administrator or support personnel.

Scott,

Have you seen the following article. This might help you. Is the situation
stated in the article the same which you are facing?

The article is
http://support.microsoft.com/default...b;en-us;214691

Joham

--
Joham


Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200508/1