How to Find Something

Have you ever needed to quickly find something? Or needed to know how many times a certain word/number/value was used? Here’s how to do it.

The fastest way to find something is to use the shortcut key CTRL+F. If you would rather not use a shortcut key, I’ll also show you how to find something using the ribbon method.

Here is a hypothetical set of spending data with categories and subcategories. Download the example to follow along.

Using the Shortcut Key CTRL+F

Let’s say you want to find each time you labeled something as “Restaurants” under SUBCATEGORY. Simply press the CTRL key, and then while holding it down, press the “F” key. Let go of both keys.

When you get this dialog box, type in what you’re looking for. In this example, we would type in “Restaurants.”

Click “Find All” if you want an overview of which cells contain “Restaurants” and how many cells contain it.

Click “Find Next” if you want your cursor to jump to the first occurrence of “Restaurants.”

Click “Find Next” again if you want to jump to the next occurrence of “Restaurants.”


Using the Ribbon Method

If you are not comfortable using shortcut keys, you can also use the ribbon. Go to the ribbon and select 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 “Find.”

When you get this dialog box, type in what you’re looking for. In this example, we would type in “Restaurants.”

Click “Find All” if you want an overview of which cells contain “Restaurants” and how many cells contain it.

Click “Find Next” if you want your cursor to jump to the first occurrence of “Restaurants.”

Click “Find Next” again if you want to jump to the next occurrence of “Restaurants.”