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, 11 views)