In this tutorial, you will learn how to search in Excel.
To search for something in your worksheet, such as a certain number or text string, use Excel’s Find and Replace tools.
Once ready, we’ll get started by utilizing real-world examples to show you how to search in Excel.
Table of Contents
Search in Excel
Before we begin we will need a group of data to search in Excel.
Step 1
First, you need to have a clean and tidy group of data to work with.
Step 2
To search in Excel, simply hold down the ‘Command’ and ‘F’ keys on the keyboard simultaneously. In this example, we are searching for the word ‘Gregory’.
Step 3
Once you are done selecting, your Excel will look like this. The word you are searching for will automatically be selected to highlight to you.
Summary
That’s all there is to it. You are welcome to copy the example spreadsheet below to see how it is done. The most crucial lesson is to enjoy yourself while doing it.
In this tutorial, I covered how to search in Excel.