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?

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?

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?