Home > Articles > Home & Office Computing > Microsoft Applications

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

This chapter is from the book

Finding Data

You will often encounter situations where you will need to find specific information in a large spreadsheet. For example, suppose you want to quickly find the row that shows the sales information for Jerry Thompson. Instead of scanning each row for the data you need, which can be time consuming, you can use Excel’s Find feature.

start.jpg

circle_1.jpg On the Home tab, click Find and Select, and then click Find or press shortcut key Ctrl+F.

circle_2.jpg In the Find What text box, enter the data you want to find.

circle_3.jpg Click the Find Next button. Excel finds the first instance of the data you typed and makes the cell that contains it the active cell. You can click the Find Next button to search for the next instance.

circle_4.jpg Click the Close button when you are done searching.

end.jpg
  • + Share This
  • 🔖 Save To Your Account