Forum Discussion

Joanna James's avatar
Joanna James
Copper Contributor
Feb 15, 2018

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 da...
excel
Brian Spiller's avatar
Brian Spiller
Brass Contributor
Feb 16, 2018

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.

Anders Mejlhede Jensen's avatar
Anders Mejlhede Jensen
Copper Contributor
Feb 20, 2018

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