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

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.

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 …

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.

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 …

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.

You can apply conditional formatting to a range of cells (either a selection or a named range), an Excel table, and in Excel for Windows, even a PivotTable report.

How to use the MATCH function in Excel to search for a specified item in a range of cells, returning the relative position of that item in the range.

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.

The CELL function returns information about the formatting, location, or contents of a cell. For example, if you want to verify that a cell contains a numeric value instead of text before you …