Check Page Setup. It sounds as if "Fit to" is set.

--
Jim
"Red2003XLT" wrote in message
...
|I have a worksheet with 5 columns and variable number of rows.
|
| When the rows of data is small, no problems with printing.
|
| With increasing numbers of rows, the resulting printed document has
shrank.
|
| What happened?