I have noticed that my Excel files hang and react slowly, so I looked up a solution, which was to find the used range and delete all the unnecessary cells. When I press Ctrl + End in my Excel file, it takes me to the “last used cell” in column XFD. Whatever row I'm in, it takes me to that row's XFD column cell.




I decided to copy my info into a brand new file, format the column widths, and save. As I edited, the file was still slow, so I did Ctrl+End again and got the same thing.


I opened a new Excel file, pressed Ctrl+End, and went to the last column (XFD) in the sheet even though I hadn't entered or modified anything. Apparently, my template is screwed up.



Is my diagnosis correct?


Any suggestions of how to fix this?


I have uploaded an empty file named XFD problem.xlsx that has this problem.

Attached Files

XFD problem.xlsx (8.1 KB, 9 views)

When I do a Ctrl+End on your file, regardless of what is selected before I do it, I always end up at cell A1.


When I copied column widths only, the last cell became the same column as the last cell of the copied range's rightmost cell, or the same as the last cell column of the source sheet if the range I was copying the column widths from was wider than the used range (last cell). Note that there were column-widths changes in the source sheet to the right of the last cell column of that sheet; these column widths were copied over but the last cell on the new sheet was still to the left (column T instead of column V).


Make of it what you will!!


If your source sheet's last cell is in column XFD and you're selecting the whole top row or all the cells in the sheet, the last cell column will be the same as your source sheet's last cell column - so if you're doing that maybe you need only to copy a smaller range's colmn widths?

Maybe Ctrl-End has been reset as a shortcut on my laptop? Weird!

So in Excel, on that sheet, if you press F5 on the keyboard, click the Special… button and double-click the last cell option, it takes you to a different place?


A keyboard shortcut can be set up in Excel; see if you have the likes of:
application.onkey "^{END}","a macro name here"
anywhere in the file or in personal.xlsb
Search for onkey in the vba.

When I press F5 etc. the cursor stays on cell A1.

Will look for that macro.
Thank you!