In order to print a sheet you have a number of interactive options available under View - Page Break Preview. Drag the delimiter lines to define the range of printed cells on each page.
To print in landscape format, proceed as follows:
Go to the sheet to be printed.
Choose Format - Page Style.
The command is not visible if the sheet has been opened with write protection on. In that case, click the Edit File icon on the Standard bar.
Select the Page tab. Select the Landscape paper format and click OK.
Choose File - Print. You will see the Print dialog.
Depending on the printer driver and the operating system, it may be necessary to click the Properties button and to change your printer to landscape format there.
In the Print dialog under Print range, select the pages to be printed:
All - All sheets will be printed.
Selection - Only the selection will be printed. If cells are selected, these are printed. If no cells are selected, all those sheets whose names (at the bottom on the sheet tabs) are selected will be printed. By pressing Ctrl while clicking a sheet name you can change this selection.
Selected cells - All selected cells are printed.
From all the paper pages that result from the above selection, you can select the range of paper pages to be printed:
All pages - Print all resulting pages.
Pages - Enter the pages to be printed. The pages will also be numbered from the first sheet onwards. If you see in the Page Break Preview that Sheet1 will be printed on 4 pages and you want to print the first two pages of Sheet2, enter 5-6 here.
If under Format - Print ranges you have defined one or more print ranges, only the contents of these print ranges will be printed.