"End" key function needed

OK, you know I've searched for this before posting!
I know that on a Mac keyboard with no "End" key, that +right arrow moves to the end of a line/row and +left arrow moves to the beginning of the line/row. What I need is something different.

Using Excel in Windows, if I have a column that has blank cells and occasionally has a cell with data in it, (or the reverse: cells that have data and occasionally an empty cell), I can press and release the End key, then press the down or up arrow to move to the next cell in the column that is or isn't empty.

However, there is no End key on my Mac, so how can I achieve the same functionality? Any ideas?

 

Using Excel 2008:
+down arrow moves down one cell
Option+down arrow moves to another space in Spaces
Control+down arrow moves to the bottom of the worksheet
fn+down arrow moves down one page

Nothing will move to the next empty/not empty cell. Again, in Windows, you achieve this by pressing and releasing the End key, before using an arrow key. On a Mac, I can't find an equivalent function.

 

Yes, I know how to create keyboard shortcuts and have already created several. However, that doesn't help when there is no menu item for the End key. You can't create a keyboard shortcut without a menu command.

 

That appears to work. Thanks! That's what I was looking for! I had searched Excel 2008's help, but found only references to the End key, never a description of how to access it without the key appearing on the keyboard.

 

The point is, my question was how to access the End key function, not how to create a keyboard shortcut. gloubibou gave me the answer I needed.