How To Search An Excel Spreadsheet

We all know that we can search in MS Excel by using CTRL + F to display the Find tab of the Find and Replace dialog box and do a search of the entire worksheet.

If you want to place a limit on your search, however, there is another way to do this. Follow the steps below:

Select the range you want to search before you press CTRL + F.

Perhaps you only want to search a specific column in your worksheet.

Selecting that column before displaying the Find tab of the Find and Replace dialog box will perform the search only in that range of cells, ignoring the rest.

To find out more about Excel Training Perth