Skip to main content
Search all of Office.com
Warning: This site requires the use of scripts, which your browser does not currently allow.
See how to enable scripts.
Select cells that contain formulas
Do one of the following:
(range: Two or more cells on a sheet. The cells in a range can be adjacent or nonadjacent.)
that includes the type of cells you want to select.
Click any cell to select all cells of this type on the active worksheet.
, and then select the check box next to the type of data you want to select.