What does the End key do?

The End key doesn't move you to the end of a horizontal line or row in Excel as it might in other programs. Because Excel rows extend endlessly, the End key needs a little direction. When you press the End key and follow the keystroke with the right arrow key, your cursor will move to the last cell that contains data in the row. Similarly, following the End keystroke with the left, up, or down arrow key will move you in the corresponding direction of the cell most extremely positioned containing data.

In StarOffice Calc, OpenOffice.org Calc and NewDeal's NewCalc, pressing the End key moves the last cell that contains data in that row. You can also get there by pressing CTRL and the right arrow key simultaneously. To move to the left most cell containing data, press CTRL and the left arrow key. Similarly with the CTRL and the up and down arrow keys. This method was inherited from early spreadsheets and was in use long before Microsoft's End key method.