;
This function examines a cell and displays information about the contents, position and formatting.
=CELL("TypeOfInfoRequired",CellToTest)
The TypeOfInfoRequired is a text entry which must be surrounded with quotes " ".
The cell to test is B1 with contents :
ABCD
The cell address:$B$1 can be determined as
=CELL("address",B1)
The column number:2 can be determined as
=CELL("col",B1)
The row number:1 can be determined as
=CELL("row",B1)
The contents of the cell:ABCD can be determined as
=CELL("contents",B1)
The type of entry in the cell:v (*Refer index below) can be determined as
=CELL("type",B1)
The width of the cell:20 can be determined as
=CELL("width",B1)
The number format of the cell:G (**Refer index below) can be determined as
=CELL("format",B1)
Formatted for braces()on +ve values (1-Yes, 0-No):0 can be determined as
=CELL("parentheses",B1)
Formatted for coloured negatives (1-Yes, 0-No):0 can be determined as
=CELL("color",B1)
Type of cell protection(1-locked,0-unlocked):0 can be determined as
=CELL("protect",B1)
The filename containing the cell:C:\[test.xlsx]Sheet1 can be determined as
=CELL("filename",B1)