Forum Discussion
Changing a calendar template
Greetings.
I am creating a calendar from a template in excel. I edited the format of one month to suit my needs. Now I want to copy the format to the other months. Simple, right? Well, I simply cannot find any information on how to do this. I've tried all of the conditional paste options. I've searched online. Everything I've tried has changed the dates. If I copy January (the modified month) to February, February turns into January. I did a lot of work to make January look the way I want it. There has got to be a way I can copy it from one sheet to the next without losing the Month/Date configuration.
2 Replies
Alien_Clerk Templates are often near to impossible to customise, so I'm not surprised that you are running into trouble. Which template exactly?
- 2 suggestions to try:
a) copy and then go to home, paste more menu and select paste formatting only
b) try using the format paintbrush. basically highlight the cells you want to copy format from, click the paintbrush, then click on the cells where you want it applied.
