Making two pages print on one page is a printer function not an Excel function
to do it in Excel
I feel your best bet is to set up a print only sheet
if for example your main sheet has 16 columns and 4 rows

on the print sheet
in A1 enter
=main!A1
and copy to H4

in A6 enter
=main!I1
and copy to P9

"AAAA" wrote:

Hi I'm an english-only speaker unfortunately forced to use a russian version
of excel right now.

The problem is that I have a lovely spreadsheet all ready to go, but it is
not very tall (i.e. low in rows) and quite wide (i.e. high in columns).
Solution: print it on two pages and then fix them together. so far so good.

However, having arranged the sheet over two pages in print preview mode, its
only printing out on the top left corner of each of the two printed pages.
destroys the effect of having on two pages.

Help! how can I tell excel to fit each half of the sheet to its respective
page?

I need step-by-step, idiot-proof instructions (e.g. third menu from the
left, second option down etc.)

Thanks. A.