How do I copy formatting in a cell reference
 

I have a spreadsheet with 13 worksheets. On the first worksheet ("summary")
I have a cell (A1) that contains the year, "2005", in 24point red font. I
would like to reference it in each of the other 12 worksheets as
"=summary!a1" and have this copy the value, "2005", and the formatting. Is
this possible? Thank you.

Hi!

When you link to a cell with a formula, (=summary!A1 is a formula), only the
value of that cell is returned, not the formatting.

Try this...

Right click any sheet tab and select: Select all sheets

In the window title bar you will notice the word [Group]. This means that
all of the sheets are grouped together as though they are a single sheet.
Whatever you do to one sheet will be done to every sheet that is in the
group.

Now then, navigate to cell A1 and apply the formatting that you want, font
size 24, color red. This formatting will be applied to cell A1 in every
sheet that is grouped.

Now, and this is a *VERY IMPORTANT* point, ungroup the sheets by either
clicking any one of the other sheet tabs or right click any sheet tab and
select Ungroup sheets.

Biff

"san jose native" <san jose wrote in
message ...
I have a spreadsheet with 13 worksheets. On the first worksheet
("summary")
I have a cell (A1) that contains the year, "2005", in 24point red font. I
would like to reference it in each of the other 12 worksheets as
"=summary!a1" and have this copy the value, "2005", and the formatting.
Is
this possible? Thank you.