[Solved] Page setup for multiple sheets

Discuss the spreadsheet application
Post Reply
Dongatrash
Posts: 36
Joined: Mon Nov 05, 2012 4:52 am

[Solved] Page setup for multiple sheets

Post by Dongatrash »

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.
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.
FJCC
Moderator
Posts: 9625
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Page setup for multiple sheets

Post by FJCC »

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.
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.
Dongatrash
Posts: 36
Joined: Mon Nov 05, 2012 4:52 am

Re: Page setup for multiple sheets

Post by Dongatrash »

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.
Post Reply