Forum Discussion
Reset the end cell
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.
I have tried to reset the last cell in a spreadsheet by selecting all of the rows below the last data row, to the bottom, selecting "clear all", saving, closing. On reopen, the last cell is unchanged. There was mention in the help of vba macros that can help. Can you point me to that?
If you are on Excel 2016 or on 2013 Pro Plus you may use built-in Inquire to clean the worksheet, you only need to activate it first https://support.office.com/en-us/article/turn-on-the-inquire-add-in-6bc668e2-f3c6-4729-8ce1-75ea20aa9d90
Not sure about previous versions.
I can't see what version I have because the "about" is grayed out. BTW I'm on a mac.
I looked at Add-ins, which is in the Insert and Tools menu, if you type "Add-ins" in the help bar. It's grayed out.
- Hi Eric, you need to delete the rows not just clear the cells.
Hi Wyn and thanks. I tried that as well but will try it again...
