Excel Tips Tutorial: How to Find and Select Content or Cells in Excel
Find & Select
When working in Excel you might have a worksheet that contains a large amount of data. If you want to locate specific data in a worksheet you can use the Find & Select command instead of searching the worksheet cell by cell.
You would click the Find All button if multiple cells contained the same data and you would click Find Next if you wanted to locate a data that was in a single cell.
- Click on the Find & Select command in under Editing in the Home tab.
- Select Find from the drop down menu and the Find and Replace dialog box will appear.
- In the Find What box enter the content that you are searching for and click Find Next or Find All.