Excel Guides

Identifying the Last Cell Changed in a Worksheet in Excel

When you have a large worksheet in Excel, it can be difficult to identify which cell was the last one changed. This is especially true if you have multiple users who are editing the same worksheet at the same time. There are a few different ways that you can identify the last cell changed in a worksheet in Excel.

One way to do this is to use the built-in function called CELL("address"). This function will return the address of the last cell that was changed in the worksheet. To use this function, simply enter =CELL("address") into any cell. The address of the last cell changed will be displayed in that cell.

Another way to identify the last cell changed is to use conditional formatting. To do this, select the cells that you want to check and then go to Home > Styles > Conditional Formatting > Highlight Cell Rules > Last 7 Days. This will apply a color to any cells that have been changed in the last 7 days. You can change the number of days to whatever you want.

If you have multiple users who are editing the same worksheet, you can also use conditional formatting to highlight cells that have been changed by a specific user. To do this, go to Home > Styles > Conditional Formatting > Highlight Cell Rules > Equal To and enter =UserName() into the box. This will highlight all of the cells that have been changed by the current user.

You can also use VBA to track changes made to a worksheet. To do this, open the Visual Basic Editor (go to Developer > Visual Basic or press Alt+F11) and then insert a new module (go to Insert > Module). Paste the following code into the module:

Private Sub Worksheet_Change(ByVal Target As Range)

    Dim strAddress As String

    'Get address of last changed cell
    strAddress = Target.Address

    'Do something with address...
    
End Sub

This code will run whenever any cell in the worksheet is changed. The address of the last changed cell will be stored in the variable strAddress. You can then use this variable however you want.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.