Solved

Formatting Worksheets in an Excel Document to be the same.

Posted on 2011-03-21
2
171 Views
Last Modified: 2012-08-13
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.
0
Comment
Question by:Newbie0000
2 Comments
 
LVL 6

Accepted Solution

by:
KnutsonBM earned 500 total points
ID: 35183123
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
 
LVL 3

Expert Comment

by:Majo2469
ID: 35184108
KnutsonBM is absolutely correct. On a side note, this kind of selection works with rows, cells, and colums as well.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Match formula returns N/A 5 25
Excel Formula 4 28
Extract first 12 digits from a string where applicable 5 27
increment numbers by 10 11 26
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now