How to use the CELL function
Until now we’ve seen how the ADDRESS function helps you find the address of a cell in Excel.
But what if you want to know about the location, format, formula, and content of a cell too🤔
The CELL function of Excel will help you fetch all these (and even other details about a cell). The syntax of this function reads as follows:
Starting with info_type, write the CELL function like this:
As you start writing the CELL function, Excel launches a drop-down menu of options for the argument “info_type“.
You can select from any of the 12 options in the drop-down menu above.
For example, select the option “Address” as the info_type argument. And Excel would return the address of the active (or the referred) cell.
= CELL (“Address”)
Note that we omitted the second argument of the CELL Function in the above example, i.e., [reference].
And so, the function returned the address of the active cell (Cell A2).