How to search for terms or values in an Excel spreadsheet, and use Find and Replace

Shutterstock

You can search in Excel with the Search Sheet bar, and use Find and Replace to swap out terms or values.

• You can search in Excel to quickly find terms or numbers in your spreadsheet.
• It's easy to search in Excel by typing into the Search Sheet bar at the top of the screen, or by using a keyboard shortcut.
• You can also search for terms or numbers and easily replace them with another value by using Find and Replace.
• Visit Business Insider's homepage for more stories.

Excel spreadsheets are a daunting affair for many.

And indeed, when you are confronting dozens of rows and columns comprising hundreds if not thousands of cells filled with all sorts of data, it's only logical to be a bit unnerved. How are you going to find that one term or figure among all that clutter?

Complimentary Tech Event

Transform talent with learning that works

Capability development is critical for businesses who want to push the envelope of innovation.Discover how business leaders are strategizing around building talent capabilities and empowering employee transformation.Know More

If you know what you're searching for, using Excel's search tools makes finding any term or number tucked into any cell quick and easy.

Here's how to search an Excel spreadsheet.

Check out the products mentioned in this article:

Microsoft Office (From $139.99 at Best Buy)

MacBook Pro (From $1,299.99 at Best Buy)

Lenovo IdeaPad 130 (From $299.99 at Best Buy)

How to search in Excel using the Search Sheet bar

1. Simply click into the task bar with the faint words "Search Sheet" at the top right corner of the spreadsheet and enter the words or numbers you wish to find.

Steven John/Business Insider

Click into the search box.

2. Hit "Enter" on a PC (or "Return" if you're using a Mac) to find the first instance, and then use the arrows beside the search term to hop to the next or previous instance.

3. You can also quickly access this search bar by using a "command + F" keyboard shortcut on a Mac, and a "Control + F" shortcut on a PC.

Steven John/Business Insider

If you can't find the terms or numbers you're looking for, be sure to double check the way you typed them into the search bar; Excel won't look for similar terms, so a mistype ruins the effort.

How to use the Replace option to swap in new terms

If you have to replace multiple instances of a term or figure in your Excel sheet, then click on the magnifying glass icon at the top right corner of the screen and click "Replace…"

Steven John/Business Insider

Select Replace under the magnifying glass.

In the pop-up box, enter the term you want to replace into the bar marked "Find what" and the new term (or number) into the "Replace with" bar and then select "Replace All" for a total swap out, or use "Find Next" to go on a case-by-case basis.

Steven John/Business Insider

You can replace all such terms or toggle through them in the spreadsheet.

Related coverage from How To Do Everything: Tech:

• How to merge and unmerge cells in Microsoft Excel in 4 ways, to clean up your data and formatting

• How to lock cells in Microsoft Excel, so people you send spreadsheets to can't change certain cells or data

• How to alphabetize data in an Excel spreadsheet by column or row, and by using shortcuts

• How to freeze a row in Excel so it remains visible when you scroll, to better compare data on different parts of a spreadsheet