Apache OpenOffice Community Forum

I created a document on the Spreadsheet. Is there any way to hide the "sheet 1" at the top, and "page 1" at the bottom of the document?

I'm going to guess that you are referring to that information in regards to a printout, as I don't recall seeing it anywhere else.
If so
1) Go to File -> Page Preview (or the Page Preview icon on the Standard Toolbar)
2) On the Preview window, click Format Page
3) Select the Header tab, and uncheck Header On (for the sheet 1)
4) Repeat step 3, but for the Footer tab (for the page 1)
NB: If you want a header and/or footer, but not the defaults, then you can change what is displayed and where (left/centre/right) on the same appropriate tabs, but you'll need to leave the Header On and/or Footer On checkboxes marked

Thanks for that info!
Dennis

It worked perfectly, thanks again.

1) Go to File -> Page Preview (or the Page Preview icon on the Standard Toolbar)
2) On the Preview window, click Format Page
3) Select the Header tab, and uncheck Header On (for the sheet 1)
4) Repeat step 3, but for the Footer tab (for the page 1)
NB: If you want a header and/or footer, but not the defaults, then you can change what is displayed and where (left/centre/right) on the same appropriate tabs, but you'll need to leave the Header On and/or Footer On checkboxes marked

If you did it, that means: You have edited the Default Page Style (or the actually applied one).

You can create and apply different Page Styles for each of the Sheets if you need it. You can vari the orientation of the sheets (Portrait/Landscape), the Header/Footer content, etc...) in one Calc DOCUMENT...

The "Styles" is the most valuable feature of the Apache OpenOffice and the LibreOffice . Use them.

I tried to paste a document to "sheet 2" to tweak my original, but it did not have the same margins as the original, and apparently it will not allow me to make changes to sheet 2?
Is there a way to delete sheet 2 completely, and on another spreadsheet document I can't find out how to delete it completely?
Dennis

To delete all of the contents:
Ctrl-A - DEL

To delete the sheet:
Right click on the TAB of the sheet - Delete sheet (from the floating menu)


As I wrote: You can set different margins to the Sheets, when you apply different Page Styles to the sheets.

Thanks again. I have much to learn.
Dennis