Change cells with same data

M

MtK

Hello Everybody, I was just wondering if there was a way in excel
(office xp), were I could change cells that all have the same data,
maybe number or text(like a word). At the same time. If there was a
command or function that would go through them all and change it if i
changed one of them. something like that. Thanks in advanced.
 
I

Interested Party

You could try Find+Replace (Ctrl+H). You tell the system what to find and
what to replace it with, click Replace All and it's done!

HTH,
Steve
 
Top