Excel Functions

Excel CELL Function

Pinterest LinkedIn Tumblr

The CELL function returns information about a cell in a worksheet. The type of information to be returned is specified as info_type. CELL can get things like address and filename, as well as detailed info about the formatting used in the cell.

Purpose of Excel CELL Function

Get information about a cell.

Return value

A text value.

Syntax

=CELL (info_type, [reference])

Arguments

ArgumentsDescriptionRemarks
info_typeThe type of information to return about the reference.Mandatory
referenceThe reference from which to extract information.Optional

Usage notes

  • When reference refers to more than one cell, CELL will return information about the first cell in reference.

Availability

Since 2007 for Windows.
Since 2011 for Mac.

Related Posts

Write A Comment