CELL Function in Google Sheets

Retrieve information about a cell in Google Sheets using the CELL function.

CELL Function

The CELL function in Google Sheets returns information about a cell’s formatting, location, or contents.

Syntax

CELL(info_type, reference)

Examples

  1. Get Cell Type

Find out the type of data in cell A1:

=CELL("type", A1)

This will output ‘v’ for value, ‘l’ for label, or ‘b’ for blank.

  1. Get Cell Address

Get the address of cell B2:

=CELL("address", B2)

This will output “$B$2”.

Common info_type Values

  • address: Returns the cell address as text.
  • col: Returns the column number of the cell.
  • row: Returns the row number of the cell.
  • type: Returns the type of data in the cell (‘b’ for blank, ‘l’ for label, ‘v’ for value).
  • ADDRESS: Creates a cell reference as text.
  • ROW: Returns the row number of a reference.