How to enter in one cell and show up in other worksheets
 

I want to enter info in cell L25 on one worksheet and have it show up in cell
L25 or several other worksheets without having to go to each worksheet and in
that cell hitting =, then clicking on the original cell over and over, is
this possible?
Thanks

How to enter in one cell and show up in other worksheets
 

Group the worksheets by click the tab for the first sheet; hold SHIFT and
click the tab for the last one (if non-contiguous, use CTRL)
Type the formula
Ungroup by clicking any one of the worksheet tabs
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Meenie" wrote in message
...
I want to enter info in cell L25 on one worksheet and have it show up in
cell
L25 or several other worksheets without having to go to each worksheet and
in
that cell hitting =, then clicking on the original cell over and over, is
this possible?
Thanks

How to enter in one cell and show up in other worksheets
 

yes it is,
by selecting all sheets that you want to enter, by holding the Ctrl key and
click on the sheet tabs and then enter = and click on the cell with info.

"Meenie" wrote:

I want to enter info in cell L25 on one worksheet and have it show up in cell
L25 or several other worksheets without having to go to each worksheet and in
that cell hitting =, then clicking on the original cell over and over, is
this possible?
Thanks