First, on the Ribbon go to the View tab under Workbook Views section and press on "Page Break Preview". If necessary drag the blue edges to define the desired print area. After this go to the Office button and under Print choose Print Preview. Under Page Setup choose the option "Fit to ´1´ page(s) wide by ´1´ tall". Click "Print" if you are satisfied with the setup.
[ Ссылка ]
