| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I change two cells (with same info) at once?
I know I've done this before, but can't remember how. I have two cells which
will have the same info on the same sheet. I am changing this info every day. How can I change them both at once? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I change two cells (with same info) at once?
Select both cells, type what you want to change and press ctrl + enter.
Hope this helps. "April" wrote: I know I've done this before, but can't remember how. I have two cells which will have the same info on the same sheet. I am changing this info every day. How can I change them both at once? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I change two cells (with same info) at once?
Maybe just link one to the other and always change just the source cell.
In F1 enter =A1 Change A1 only to change both. Gord Dibben MS Excel MVP On Wed, 10 Sep 2008 18:06:01 -0700, April wrote: I know I've done this before, but can't remember how. I have two cells which will have the same info on the same sheet. I am changing this info every day. How can I change them both at once? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I keep change info on screen longer and change its size? | Excel Discussion (Misc queries) | |||
| How can I change info in one tab when I change info in a seperate | Excel Discussion (Misc queries) | |||
| Link info in one cell to info in several cells in another column (like a database) | Excel Discussion (Misc queries) | |||
| how to change info in a graph | New Users to Excel | |||
| change info in other cells when i change a number in a drop list? | Excel Discussion (Misc queries) | |||
Linear Mode
