Returns information about the formatting, location, or contents of a cell.
구문
CELL(info_type, [reference])인수
info_type필수
A text value that specifies what type of cell information you want to return.
reference선택
The cell that you want information about; if omitted, information is returned for the last cell that was changed.
The CELL function is used to retrieve specific metadata about a cell, such as its address, row number, or formatting style. It is often used in complex formulas to track changes in a worksheet's structure or appearance.
=CELL("row", A1)→1Returns the row number of cell A1.
=CELL("address", B5)→$B$5Returns the absolute address of cell B5.
Select a cell
Click on the cell where you want to display the information.
Enter the formula
Type =CELL followed by the info type in quotes and the target cell reference.
No, the CELL function does not automatically recalculate when the formatting of the referenced cell changes; you must force a recalculation.