I have one spreadsheet with two sheets (tabs) in it.
I want one of these sheets to always print in Landscape, the other to always print in Portrait.
However, whenever I set one up for Landscape, it changes the other sheet and vice versa.
Is there a way to do this please?
Hello,
Styles -> Manage Styles- Click the second icon beneath the label Styles (name Page Styles when hovering over)
Right click on Default -> New- Provide a Name (e.g.
DefaultPortrait - Select tab
Page - Set orientation to
Portrait - Click
OK - Repeat the steps for another Page Style (e.g. name it
DefaultLandscape) - Assign the page style to the sheet by selecting a sheet and clicking on the style in Style Manager until it turn its color.
Hope that helps.
1 Like
Fantastic, thank you so much.
I’ve never used styles before, it worked perfectly.
So happy now.