Jump to content


Excel question for ceating next year's schedule

Recommended Posts

I am creating next year's schedule in Excel. Each of the pages after the first one will have the same format, only with different content in the cells. How do I keep from having to reformat each page. I have copied the second page and pasted. It will keep all formatting except the row height. And my row height varies from row to row.


Thanks, I am sure it's something basic but my youngest ds isn't here right now:D

Link to comment
Share on other sites

:glare: If these are going to be two separate files...I usually save the original document and then close it. Reopen document from saved files and change the content in the cells. Go to Save As and save it again with a different name. This will give you two separate files without having to go through the formatting junk. I hope this works for you...

Link to comment
Share on other sites

First, make a back up copy of the worksheet/workbook in case anything goes wrong! :)


Now, open the worksheet that you want to re-use. Go to the Edit menu & choose Move or Copy Sheet. Select Copy Sheet.


This will create a copy of the sheet and you can fill in whatever info you want. For the next week, do the same thing (copy the blank worksheet).


I think this is what you're asking. HTH!


Link to comment
Share on other sites

If I only wanto keep the general stuff, font, row and column sizes, that sort of thing..


I open the new worksheet first, then...


I click on the little box in the top left corner (no letter or number), that selects the whole worksheet and then I paste it in. (I do this for SOTW review questions - I delete all the rows I typed the last questions in and start over with blank rows that are formatted the way I wnat them.)

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...