Excel CELL formula


If you're editing a column of data in an Excel worksheet and you want to keep track of which was the last cell that you edited, use the CELL formula. Just type in =CELL("address"), and it will automatically update with the location of the most recently edited cell any time a change is made.