• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Finding Data

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

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

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. Click Find Next to search for the next instance, or Close to end.

INTRODUCTION

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.


TIP

Finding all instances of data

Click the Find All button in the Find and Replace dialog box to view a list, complete with cell locations and worksheet tab names, of all the instances of the data you entered in the Find what text box.


  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint