I have a sheet which has several columns and hundred of rows.

Now I need to print only first two column, which I have selected and set the
print area. Its fine, on preview it shows normal. the first page, second
page etc.
BUt my requirement is that before moving to next page, is it possible to
print at the side of the same page as it has enough space, so that it can
reduce my pages.
For example, I word and and Ms Access we have this option that for printing
we increase the number of colunm and its width.

Please advise its method to be done.

Regards.

Irshad