See below for a full list ofinfo typesandformat codes.
The CELL function takes two arguments:info_typeandreference.Info_typeis a text string that indicates the pop in of information requested.
See the table below for a full list of info types.Referenceis a cell reference.Referenceis typically a single cell.
Ifreferencerefers to more than one cell, CELL returns information about thefirstcell in reference.
For certain kinds of information (like filename) the cell address used forreferenceis optional and can be omitted.
To avoid confusion, use A1 forreference.
Note: the CELL function is avolatile functionand may cause performance issues in large or complex worksheets.
For example, =ADDRESS(1,1) returns $A$1.
To use the INFO function, supply the bang out of information you want as text.
There are seven types of information available, summarized in…
