Dafaults for new Worksheets

  • Thread starter Thread starter John
  • Start date Start date
J

John

I have a file that I continually add worksheets to. With each new worksheet
I have to reset the page set-up with regards to margins; header and footers
etc. I assumed that copying a correct worksheet to the new one would simply
copy over all my requirements but it doesn't.

Can this be done once in the file instead of each new worksheet

Thanks
 
Hi John
you can create a teplmate for new sheets/workbooks. Have a look at the
Excel help for 'Templates'
 
I don't think there is anything in Excel you don't know Frank!

Thanks again
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Email Worksheet Question 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Copy a worksheet to a new workbook 6
Print and page settings of workbook 8
Copy certain rows to new worksheet 1
Macro won't run correctly when a worksheet is hidden 0
Display Sheetname in a cell 7
Excel Columns moving up and down on their own in a worksheet. What Goes? 2

Back
Top