Workbook settings

  • Thread starter Thread starter Cheryl Kelemen
  • Start date Start date
C

Cheryl Kelemen

Hello;

I am an accountant for a big law firm and I do weekly,
monthly and year end reports based on the data that is
entered through out the year. Is there anyway to make
your worksheets within your workbook have the same
uniformity with the settings for format, font, etc. once
you set them once for one worksheet? For example, if I
set up one worksheet with the fonts that I want can I
transfer those settings to the next worksheet within the
same workbook to make all my reports that I have to do
more uniform? Right now, I have to do one report and then
set the fonts all over again to print out another one. I
am going crazy. There has to be a better and easier way
than this. Did I mention that I was a perfectionist. (lol)
Any help in this matter would be greatly appreciated.
Thanks. :)
 
One thing you can try is grouping the worksheets before setting up the
fonts, etc.

To group, hold CTRL and click on worksheet tabs. Then let go of CTRL, change
fonts, etc; and the changes will be made on each worksheet. Great tool if
you have many sheets that have to look the same.

To ungroup, click on any one sheet tab.
 
Hi

Design one sheet (it can be same the users will use later, or you create an
empty 'template' with all design and formulas ready and you simply hide it
from user).

At any time you need a new sheet, right-click onto sheet's tab and select
'Move or copy' from dropdown list. Check 'Create a copy' field, select the
destination, and press OK. Rename the newly created sheet. If you copied
some sheet which was in use, then likely you must clear abundant contents
(NB! Clear, not delete!) - if you used special 'template' sheet, then you
don't need to bother with this.
 
Back
Top