Using Find & Replace | How to become an Expert of MS Excel - Class 6 PDF Download

Introduction

To find cell content:

• From the Home tab, click the Find and Select command, then select Find from the drop-down menu.
  
• The Find and Replace dialog box will appear. Enter the content you want to find. In our example, we'll type the department's name.
• Click Find Next. If the content is found, the cell containing that content will be selected.
• Click Find Next to find more instances or Find All to see every instance of the search term.
  
• When you are finished, click Close to exit the Find and Replace dialog box.
  

You can also access the Find command by pressing Ctrl+F on your keyboard.

Click Options to see advanced search criteria in the Find and Replace dialog box.

To replace cell content:

• From the Home tab, click the Find & Select command, then select Replace... from the drop-down menu.
  
• The Find and Replace dialog box will appear. Type the text you want to find in the Find what: field.
• Type the text you want to replace it with in the Replace with: field, then click Find Next.
  
• If the content is found, the cell containing this content will be selected.
• Review the text to make sure you want to replace it.
• If you want to replace it, select one of the replace options. Choosing Replace will replace individual instances, while Replace All will replace every instance of the text throughout the workbook. In our example, we'll choose this option to save time.
  
• A dialog box will appear, confirming the number of replacements made. Click OK to continue.
  
• The selected cell content will be replaced.
  
• When you're finished, click Close to exit the Find and Replace dialog box.

Generally, it's best to avoid using Replace All because it doesn't give you the option of skipping anything you don't want to change. You should only use this option if you're absolutely sure it won't replace anything you didn't intend it to.