Formatting Worksheets in an Excel Document to be the same.

I have one excel document and have to create about 30 worksheets within it, I setup one worksheet with the Page Setup, formatting etc that I want. I want to make every worksheet the same, I tried to copy and paste special but that doesn't seem to keep the page setup or some of the formatting, is there any way to do this once and then have every worksheet open with the same settings?

Thanks in advance for the help.
Newbie0000Asked:
Who is Participating?
 
KnutsonBMConnect With a Mentor Commented:
if you select all of the tabs at the bottom (select the first one, hold shift, select the last one), select all within one of the worksheets, and do your formatting, it changes the format on all sheets, same goes for adjusting cell width
0
 
Majo2469Commented:
KnutsonBM is absolutely correct. On a side note, this kind of selection works with rows, cells, and colums as well.
0
All Courses

From novice to tech pro — start learning today.