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.
![](https://static.wixstatic.com/media/af7fa4_9d993972ea744306aecdbfcf156c492a~mv2.png/v1/fill/w_70,h_60,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_auto/af7fa4_9d993972ea744306aecdbfcf156c492a~mv2.png)