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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
CountIF Question 3
one cell in my worksheet appears blank, but answr shows in formula 6
Code to format cells on several worksheets 2
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Use worksheet name in one cell as part of reference in other cells 3
Tie additional cells to cell automatically updated 1

Back
Top