Forum Discussion
Andrey3339
Apr 09, 2024Copper Contributor
how to return to the last line write in excel after cleaning a filter
Hello everyone, I need a little help. I manage the hardware management of the IT department, and I have an excel with 4200 lines, on the column heads there are filters and I would like to get...
- Apr 09, 2024
CTRL+END always goes to the lower-right corner of the used range.
If this not where your data ends then delete the extra row/columns and save the workbook.
Andrey3339
Apr 09, 2024Copper Contributor
Doesn't work, instead of cell A4420 it takes me to cell K4774 😞
Detlef_Lewin
Apr 09, 2024Silver Contributor
CTRL+END always goes to the lower-right corner of the used range.
If this not where your data ends then delete the extra row/columns and save the workbook.