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.
[Solved] Page setup for multiple sheets
-
Dongatrash
- Posts: 36
- Joined: Mon Nov 05, 2012 4:52 am
[Solved] Page setup for multiple sheets
Last edited by Dongatrash on Mon May 11, 2026 4:36 am, edited 2 times in total.
OpenOffice 4.1.15 on Windows 10 Pro. Folk like you helping folk like me, makes the world an easier place to be.
Re: Page setup for multiple sheets
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.
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.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
-
Dongatrash
- Posts: 36
- Joined: Mon Nov 05, 2012 4:52 am
Re: Page setup for multiple sheets
Oh, thanks very much for that!
OpenOffice 4.1.15 on Windows 10 Pro. Folk like you helping folk like me, makes the world an easier place to be.