Microsoft Office Tutorials and References
In Depth Information
Replacing Cell Entries
of matching cell entries, press the Shift key while you click the Find Next
button in the Find and Replace dialog box.
Replacing Cell Entries
If your purpose for finding a cell with a particular entry is so that you can
change it, you can automate this process by using the Replace tab on the
Find and Replace dialog box. If you click Home Find & Select Replace or
press Ctrl+H or Alt+HFDR, Excel opens the Find and Replace dialog box with
the Replace tab (rather than the Find tab) selected. On the Replace tab, enter
the text or value you want to replace in the Find What text box, and then
enter the replacement text or value in the Replace With text box.
When you enter replacement text, enter it exactly how you want it to appear
in the cell. In other words, if you want to replace all occurrences of Jan in the
worksheet with January, enter the following in the Replace With text box:
January
Make sure that you use a capital J in the Replace With text box, even though
you can enter the following in the Find What text box (providing you don’t
check the Match Case check box that appears only when you choose the
Options button to expand the Find and Replace dialog box options):
Jan
After specifying what to replace and what to replace it with (as shown in
Figure 6-11), you can have Excel replace occurrences in the worksheet on a
case-by-case basis or globally. To replace all occurrences in a single
operation, click the Replace All button.
Figure 6-11:
Use Replace
options to
change
particular cell
entries.
Search JabSto ::




Custom Search