Home > Articles > Home & Office Computing > Microsoft Applications

  • Print
  • + Share This
This chapter is from the book

Finding Data

There might be times when you’ll need to find specific information in a large spreadsheet. For example, suppose you want to quickly find the row that deals with sales data in Region 5 of your company. Instead of scanning each row for the data you need, which can be time-consuming, you can use Excel’s Find feature.

start.gif

1.gif Open the Edit menu and choose Find. The Find and Replace dialog box opens with the Find tab displayed.

2.gif In the Find what text box, type the data you want to find.

3.gif Click the Find Next button.

4.gif Excel finds the first instance of the data you typed and makes the cell that contains it the active cell. Click Find Next to search for the next instance, or Close to end.

end.gif

  • + Share This
  • 🔖 Save To Your Account