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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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.
 
Back
Top