Ask Your Question

How do I save multiple sheets in Calc?

asked 2015-01-02 20:52:03 +0100

Macnerd gravatar image

I have my checkbook register in Writer now. It started back in September of 2013. So, in order to get to January 2015, I have to do a long scroll down to January 2015. I'd like to try saving the individual months on separate sheets. I'd have to copy & paste for each month onto a separate sheet. Then I want to gather sheets for a particular year into one document. So, I'd have a file for 2013 & a file for 2014 & a file for 2015, etc. How do I do that?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-01-03 00:53:23 +0100

razon_22 gravatar image

I'm attaching a checkbook register file for Calc as a guide. In the template, you will need to create a sheet for each month of the year and save it as 2014 for example. To do that, right click on one of the sheet names, choose Move/Copy Sheet, select Move to end position and give it the name Mar. Repeat for other months. Save it with the filename 2014. Then select Jan 2014 data from your Writer document and paste it into the Jan. sheet in the template. Continue with the other months. Save the document. Open the template again, save it as 2015 and begin pasting the 2015 data into it.checkbook-reg.ots

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-01-02 20:52:03 +0100

Seen: 525 times

Last updated: Jan 03 '15