This step-by-step article describes how to find data in a table (or range of cells) by using various built-in functions in Microsoft Excel. You can use different formulas to get the same result.

To search the entire worksheet for specific cells, select any cell. To search for specific cells within a defined area, select the range, rows, or columns that you want.

Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter.

Use VLOOKUP, HLOOKUP, and other functions like INDEX and MATCH to search for and find data based on values you enter. This article gives you a quick VLOOKUP refresher, then links to more.

Use the Find and Replace features in Excel to search for something in your workbook, such as a particular number or text string. You can either locate the search item for reference, or you can …

To find cells that contain formulas, click Home, Find & Select, and Go To. Click Special, and then click Formulas. You can search part or all of a worksheet.

This can be frustrating because Excel doesn't sort data in a column that contains merged cells. Following the steps below, you can find all the merged cells in your worksheet and then unmerge …

Learn how to use the percentage formula in Excel to find the percentage of a total and the percentage of change between two numbers. Try it now!

You can see details of who changed what, where, and when, along with the previous value of the cell for quick reversion. You can narrow down the list of changes by selecting any sheet, range, or individual …

Learn how to find text inside cells, when the case of the text doesn't particularly matter.