Last used cell in new Excel file is column XFD.
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.
|