Limit Search & Replace's Replace All?

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

I there a way to limit search and replace's (Ctrl + H) replace all to
just a selected cell range, without using VBA?

I like replace all because it is fast, but I'm concerned about it
changing cells I don't want changed.
 
select the range by highliting it,
then find and replace,
this should only replace in the range highlite
 
And make sure that the selection contains at least 2 cells--else all cells will
be used.
 
Unless you *Don't* use "Replace All" for single cells.
Just click "Replace".
 
Highlight the cells as previously suggested, once you have run the find all,
then re highlight the same selection and if you click replace all, only the
highlighted cells are replaced.

This is in Excel 2003
 
You must log in or register to reply here.

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

Find/Replace - from old to new 1
Search only values, then replace 3
SEARCH AND REPLACE 3
Replace zero values with blank 3
Find and Replace 3
Word Globally Changing Specific Color Highlight to Background Color 0
Find/Replace Question 3
Replacing Character in Cell - Please Help 1

Back
Top