Ask Your Question
0

How can I make sheets for each month, while maintaining consistent formatting?

asked 2021-05-09 11:00:00 +0000

woof gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
2

answered 2022-03-02 01:00:00 +0000

lalupa gravatar image

You can make sheets for each month and maintain consistent formatting by creating a template with the desired formatting and saving it as a blank sheet.

  1. Open a new sheet and format it to your desired specifications.

  2. Save this sheet as a template by going to File > Save as Template.

  3. Give the template a name and click on Save.

  4. Close the template sheet.

  5. Create a new sheet for the first month of the year by going to File > New sheet from template.

  6. Select the template you just created and click on Create.

  7. Rename the sheet to the name of the month.

  8. Repeat steps 5-7 for each month of the year.

By using this method, each sheet will maintain the same formatting as the template sheet.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer


Question Tools

Stats

Asked: 2021-05-09 11:00:00 +0000

Seen: 9 times

Last updated: Mar 02 '22