Whenever you open a new file in Spreadsheet, it is given a default set of margins. To change these defaults for the current spreadsheet, select the Page Setup command from the File menu. The "Page Setup" dialog box is displayed.
Here’s how the different Margin and settings affect your page:
As the diagram above shows, all the measurements are from the edge of the page.
The header and footer sit within the top and bottom margins respectively. So if your top margin is too small, you won't see all your header text. To control the margins for header and footer, select Header & Footer from the Format menu. Enter a value in the From edge box in the header and footer tabs.
If you want to set new default margins for all subsequent spreadsheets then select Options from the Tools menu and click on the Page Margins, Header and Footer tabs. The new default settings will not affect existing spreadsheets or the current one if its settings have already been altered.
Note: To change the units of measurement used, select the Options command from the Tools menu and click on General. You have a choice between S.I. and Imperial units.