Let me clarify further. I prefer going to other sheet, then insert equal sign
(or plus sign instead equal) then click on tab Sheet1 and choose cell A1. I
got the sheet part of reference automatically. Sure, I can start in Sheet1,
too. In B2 I insert equal sign (or plus sign) then click on other sheet tab,
than back on tab Sheet1 and then cell A1. Same result, more clicks :-)

"Alojz" wrote:


U are correct, unless u prefer combination of typing and clicking. I prefer
clicking when referencing to avoid mistyping.
"akphidelt" wrote:

That is not true at all. You can do all this on sheet one... just reference
the sheet to itself.

"Alojz" wrote:

Do almost the same: highlight all sheets, then insert the formula in last
sheet, for instance in B1: =Sheet1!A1, hit enter, click on some other sheet
to undo shift action.
In all sheets, B1 cell will display the content of A1 cell from Sheet1. The
trick is, u have to start inserting on the different sheet when referencing
the given cell together with link to proper sheet while clicking on cell u
want to be referenced.

"Barbara" wrote:

Thank you, but what do I use for the formula?

"akphidelt" wrote:

Hilight all the sheets holding down the SHIFT key.
Then type in the formula where you want it... and then click on another
sheet to undo the shift action.

"Barbara" wrote:

I have a workbook with multiple worksheets. I want to enter a formula in
certain cells that will automatically put whatever text I put in a certain
box into all the worksheets. For instance, if I type in the Agency Name, I
want it to go into that cell in each worksheet. Can anyone tell me how to do
that?

Thanks