Alternatively, you can use VBA to achieve the desired behavior of returning to the last row written after cleaning a filter in Excel. Here is an example code. Private Sub Worksheet_Deactivate() ' Store the address of the active cell before deactivating the worksheet ActiveWorkbo...
If this not where your data ends then delete the extra row/columns and save the workbook. Andrey3339 Alternatively, you can use VBA to achieve the desired behavior of returning to the last row written after cleaning a filter in Excel. Here is an example code. Private Sub ...