How to Find and Replace Something

In the last post, I showed you two ways to quickly find something. But what if you wanted to not only find something, but also replace that something with something else?

Well that’s just as easy to do! Let’s use that same data set and go through an example of replacing data. Download the sample data set to follow along.

Let’s find every occurrence of “Restaurants,” and replace them with “Dining Out.” The fastest way to do this is to use the shortcut key CTRL+H. I will also show you how to use the ribbon method if you don’t want to use the shortcut key.


Using the Shortcut Key CTRL+H

Simply press the CTRL key, and then while holding it down, press the “H” key. Let go of both keys. The “Find and Replace” dialog box will appear.

Next to Find what: type “Restaurants,” and next to Replace with: type “Dining Out.”

Then click “Replace All.” All of the cells that previously contained “Restaurants” will now contain “Dining Out.”

If you wanted to navigate to each occurrence of “Restaurant” and replace them one by one, you would just click “Replace” instead of “Replace All.”


Using the Ribbon Method

If you are more comfortable using the ribbon, here’s how to do it. First go up to the ribbon, and click the HOME tab.

Click the button that says “Find & Select” all the way on the right-hand side of the ribbon.

When the drop-down menu appears, click “Replace.” The “Find and Replace” dialog box will appear.

Next to Find what: type “Restaurants,” and next to Replace with: type “Dining Out.”

Then click “Replace All.” All of the cells that previously contained “Restaurants” will now contain “Dining Out.”

If you wanted to navigate to each occurrence of “Restaurant” and replace them one by one, you would just click “Replace” instead of “Replace All.”