Mac Excel Control Shift RIght Arrow It's been a while since I used Excel on a PC. 

In Excel on a PC, I believe if you have a set of data and want to select all the cells in the same row from where the cursor is to the last cell below a set of data, you could use Ctrl - Shift - &#x2190;. On a Mac (Excel 2011) this selects all the cells until the end of the entire row.

Using Excel 2011 (Mac), how can I select all the empty cells in a row until beneath a set of data? 

The reason for doing this is if I want to copy the current row and paste that to another row of data. I should be able to copy the current row, then hit down, then (I thought) Ctrl - Shift - &#x2190;, then paste and I would paste in another set of data.
I found it:  Fn + Shift + Option (Alt) + &#x2190;