Forum Discussion
Reset the end cell
I need information on how to reset the end cell in Excel 365. My current worksheet has 28K lines of data, but the end cell is at 1048576. I've tried the obvious select all open rows outside my data, then clear and/or delete, then save workbook, close and reopen. But, in this case it doesn't work. Thanks.
14 Replies
I've seen this too and the best way I've found to consistently fix it is to copy the desired range and paste to a new sheet.
I am usually helping a co-worker with this and really don't know where they get this abnormality. Sometime selecting the Rows and Columns and using right-click + delete works, but not always.
For some reason, I never have the issue with any of my workbooks.
I have a problem like this.
If you like to test this:
1. start a new empty sheet
2. type a text/number in cell P25
3. Ctrl HOME brings the cursor to A1
4. Ctrl END brings the cursor back to P25
...
5. delete the text in P25
6. Ctrl HOME brings you to A1
7. Ctrl END brings you to ... P25, .... but nothing's there anymore!
I found a article: "Locate and reset the last cell on a worksheet" in support.office.com
But it dosn't work in my Excel 2016
Hi Anders,
In your sample click Save after the step 5 or 6, with #7 you will stay on A1 then.
Above if you didn't change format of the cell(s) you emptied. If so, first Clear All as in support article, and after that Save.
Another way if you have Inquire in your version, apply Clear Excess Cell Formatting from the menu in the ribbon after that tab.
If not, alternative VBA macros exist.
Latest two are suitable if you have quite a lot of such cells, usually within the file with long history.
- Hi Joanna
Are you actually deleting the rows or just pressing delete on the keyboard?
Normally deleting the rows and saving / reopening fixes it HI Joanna
Sorry I'm not quite understanding you (may just be me), what do you mean by resetting the last cell? Are you attempting to delete the cells you aren't using outside the 28k cell range?
Cheers
Damien
