How can I change two cells (with same info) at once?

A

April

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?
 
A

art

Select both cells, type what you want to change and press ctrl + enter.

Hope this helps.
 
G

Gord Dibben

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
 
Top