Find and replace

1. On the Home tab, select   Find & Select and choose   Replace. 
   To limit find and replace to a column, row, or range, select those first. 

2. Enter what you want to find in Find what and what to replace it with in Replace with.

3. Select Options, and under Within, choose Sheet or Workbook.

4. Choose Replace or Replace All. 

Tip: From the keyboard, press Ctrl+F to find, or Ctrl+H to replace.

To use wild cards and more, see Find or replace on a worksheet.

1. On the Home tab, select   Find & Select and choose   Replace. 
   To limit find and replace to a column, row, or range, select those first. 

2. Enter what you want to find in Find what and what to replace it with in Replace with.

3. Select Options, and under Within choose Sheet or Workbook. 

4. Choose Replace or Replace All. 

Tip: From the keyboard, press control+H to find or replace.

To use wild cards and more, see Find or replace on a worksheet.

1. On the Home tab, select  Find & Select and choose   Replace. 
   ​​​​​​​To limit find and replace to a column, row, or range, select those first. 

2. Enter what you want to find in Find what and what to replace it with in Replace with.

3. Select Search options, and under Within, choose Sheet or Workbook.

4. Choose Replace or Replace All. 

Tip: From the keyboard, press Ctrl+F to find, or Ctrl+H to replace.

To use wild cards and more, see Find or replace on a worksheet.