| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| enter data two worksheets but not in the same cell as first | Excel Worksheet Functions | |||
| enter text in cell and have value change in all worksheets; with l | Excel Discussion (Misc queries) | |||
| enter 5 in 1 cell, show first 3 in other cell | Excel Discussion (Misc queries) | |||
| Enter "1", cell show ".01". Why? | Excel Discussion (Misc queries) | |||
| enter a time into a cell, have the cell show two times the entry | Excel Worksheet Functions | |||
Linear Mode
