[Solved] Save formatting for section/page A1 to H12

Discuss the spreadsheet application
Locked
greypoet
Posts: 2
Joined: Thu Apr 23, 2026 2:31 am

[Solved] Save formatting for section/page A1 to H12

Post by greypoet »

I am trying to set up a custom budget form and would like to copy/paste the formatting for each month without having to format each item. For example, section/page A1 to H12 Is there a way to do this?
Thank you, Jim
Last edited by MrProgrammer on Thu Apr 30, 2026 11:30 pm, edited 2 times in total.
Reason: Edited topic's subject
Open Office 4.1.16 on Windows 10
FJCC
Moderator
Posts: 9644
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: How to save formatting for section/page A1 to H12?

Post by FJCC »

The cell formatting is transferred by the standard copy/paste process, so I don't understand your problem. Could you upload a simple example and explain what results you want to achieve in that document?
To upload a document, click Post Reply and look for the Attachments tab just below the box where you type a response.
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.
User avatar
RoryOF
Moderator
Posts: 35262
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: How to save formatting for section/page A1 to H12?

Post by RoryOF »

Doing a task similar to this, I was able to right click on a sheet tab, choose Copy a Sheet, then change my key date at top of the new sheet to the first day of the correct month. I did this for the eleven months remaining in the year after I had set up my first sheet for January.
Apache OpenOffice 4.1.16 on Xubuntu 26.04.1 LTS
greypoet
Posts: 2
Joined: Thu Apr 23, 2026 2:31 am

Re: How to save formatting for section/page A1 to H12?

Post by greypoet »

Thank you FJCC. The solution was too simple and I was overthinking. Fixed easily.
Open Office 4.1.16 on Windows 10
Locked