Please enable JavaScript to view the comments powered by Disqus.


Use MS Excel's CELL() formula to find the address of a cell

The function CELL() takes various arguments, that include cell address, row and column number, cell width, content type, color, filename and its cell's format. Here the first argument of the formula will be "address" so that it can return the cells address. In a similar way one can retrieve any of the listed information. 

Used Functions

Category: Information

Returns information about the formatting, location, or contents of a cell


CELL(info_type, [reference])

Lets chat on this