How to search for terms or values in an Excel spreadsheet, and use Find and Replace
- 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?
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:
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.
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.
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…"
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.