How to Replace Multiple Values in Excel

This guide provides step-by-step instructions on how to replace multiple values in Excel. It is helpful for anyone who needs to quickly and efficiently replace specific values in their Excel spreadsheet.

Adrienne Todd
|
6 steps
|
16 seconds

In the "Home" tab, click "Find & Select" in the ribbon.

Click "Replace..." in the dropdown menu.

Type the value you'd like to replace in the "Find what" field.

Type your replacement value in the "Replace with" field.

Click "Replace All."

Click "OK."