Andrew said:
This seems like a very simple question but I can't find
the answer in any of the help screens:
How do I format multiple worksheets so they are all the
same? I am mainly intersted in column widths (but also
colours and cell borders etc.) - I want column widths on
all worksheets to be the same as on the first worksheet
but I can't find a setting for this. I'm on Excel 2003.
Advice would be greatly appreciated.
Thanks.
Andrew
First of all group the worksheets that you want to be formatted the same. To
do this, single-click the tab of the left-most worksheet in the group, then
Shift-left-click the tab of the rightmost worksheet - this will group these
two sheets and all those between (use Ctrl-left-click to add individual
worksheets to the group if they aren't in a contiguous sequence).
Once you've grouped the desired worksheets, any cell-formatting you apply to
the active sheet (= the one with its name in bold on the worksheet tab),
including setting column-widths and row-heights, will apply to the
equivalent cells/columns/rows in all worksheets in the group. Beware,
however, that some changes you make to grouped worksheets (e.g. via Page
Setup - setting page breaks, print area and print titles, for example) will
only apply to the active sheet. In these cases, it's best to set up one
worksheet first as a "template" and then copy this sheet x times.
When you group worksheets to apply common formatting, be careful to un-group
the worksheets when you want to modify only one worksheet. It is all too
easy to group worksheets in order to set up a common "template" across more
than one worksheet, only to forget to un-group them when you want to enter
data on individual worksheets! To un-group, just right-click one of the tabs
and click Ungroup Sheets on the pop-up menu.
