Change cells with same data

  • Thread starter Thread starter MtK
  • Start date Start date
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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why did auto calculate suddenly change to manual calcu... 4
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
sync same cell value in multiple places 2
Linking cells with changing format 3
Need help deleting data 2
Change cells with same text 2
Change all text on Spread sheet 1
Numbers change in cell even when formatted as text 4

Back
Top