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?
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?