Apache OpenOffice Community Forum

I have a spreadsheet that has 2 horizontal sheets to print, and one portrait sheet to print.
Why can't I set each SHEET to have it's own page setup?
I'm continually having to change the page setup, and it stuffs up the page preview.

Each sheet can have its own page set up. The page set up is determined by the page style. The page styles are accessed with the Styles & Formatting dialog that can be reached in several ways.
Select the menu Format -> Styles & Formatting. The small tool bar that opens will have two icons near the top left. The one on the left is for selecting cell styles and the other is for page styles. Click the page styles icon. You should see a list of the styles Default and Report. Right click on Default and select New. Give the new style a name and set it up how you want. Click OK when you are done but leave the Styles & Formatting tool open. Go to a sheet to which you want to apply the new style and then double click the new style's name in the Styles & Formatting tool. That will apply the style to the sheet.

Oh, thanks very much for that!