Want to make copies of a working sheet within a spreadsheet file like a template and then make changes to the copy without having any and all changes rippling across all the copies I make. If go Menu Bar → Format → Page → Organizer I have a name like PageStyle_{sheet name} created by LibreCalc. Problem is I want EACH NEW SHEET TO NOT HAVE THE SAME “Organizer” name while initially being formated alike. Then any change to the sheet remains ONLY on that sheet. If I now make a change to the footer of one sheet, it now makes ALL the footers with the same change since they all have the same “Organizer” and I can’t change it. Argh!!! I need EACH sheet to be independent. I tried the Paste Special selecting all but the format which works; BUT, I now loose ALL the page styling going back to a blank slate. I want to have ALL the style BUT NOT any link making future changes to ripple across all the copies.
- Open the Sidebar and select the Styles pane.
- Click the Page styles icon (third from left at the top)
- Right click Organizer and select New. Give it a name, let’s call it Subsidiary
- Subsidiary has the same attributes as Organizer so Edit that style to change what you want.
- Click in each of the other sheets and double click the Page style Subsidiary to apply it.
- Copy the Subsidiary sheet instead of Organizer for future sheets