Question

[Dan Wilson]

Good day and Happy New Year. I am running Excel out of Office 365 (updated) on Windows 10 Home (updated). I have a worksheet that contains 3500 Rows with 17 Columns of data. When Column A is the first Column on the left side of the screen, there are still three empty, unused Columns at the right side of the screen. Every time that I execute "Control-End" to add more row(s) of data at the end of the list, the screen skips Column A and shows me Columns B through whatever space is left to the right. This includes several Columns that are empty and unused. If I click on the arrow at the bottom of the screen or move the bar, Column A then becomes available. Any idea of what is causing this? Thank you for any help with this.

 

[Peter_SSs]

Try selecting the whole of those empty/unused columns at the right and delete them, then save your workbook. Now try Ctrl+End again

 

[Dan Wilson]

Good Peter_SSs and Happy New Year. Thank you for responding to my question. Your response worked. At first, I deleted a few unused Columns and tried Control-Home, then Control-End with no change. After deleting unused Columns all the way out to Column AAA followed by Save, Close and Re-open, it now works correctly. I noticed that when i did the Control-End prior to fix, the cursor went to the last Row and sat in the second unused Column in that Row. Perhaps there was something in than cell that I could not see. Well done.

 

[Peter_SSs]

Glad you have it sorted. Thanks for letting us know.