Strange behavior of left arrow key in Excel 2010

When I press the left arrow to return to column A - it will not stop at column A but will continue to wrap around to the end (column XEP or something huge like that). How do I make it stop when it gets to A?

Thank you I understand the home key. Let me restate my question. For example I am at cell number BH21 and for what I'm working on I need to use the left scroll button to move quickly along the row until I reach A column. My problem is that moving that quickly the left arrow button doesn't stop when it reaches A column but just keeps going and wraps around to the very end column XEP21 or whatever the end is. I was already using the spreadsheet with no problem then after modifying a few things this occurred.

Solution 1:

I’m not 100% sure what you want to learn.  If you want to know how to get to Column A in the current row, try just pressing Home.

Solution 2:

What's going on is that certain calls are unlocked (so you can edit them), but when the author protected the sheet, they chose (only) "Select unlocked cells", which prevents the end-user from clicking on locked cells, and turns on that arrow-key wrapping you are asking about.

If you unprotect the document and then protect it again, only selecting both "Select locked cells" and "Select unlocked cells", then the end user can access locked cells (just not change them), and the arrow-keys will work like they normally do (no wrapping).