What prints out is generally set by the range you have set for printrange.

First set the printrange then in page setup set that range to "Fit to:1 wide
x1 tall" if you need to.


Gord Dibben MS Excel MVP

On Tue, 17 Nov 2009 12:17:01 -0800, xicapaty
wrote:

I want my worksheet to be on one page so that a lot of pages don't print out
if I forget to specify only one page when I print.