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 – ←. 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 – ←, then paste and I would paste in another set of data.
Best Answer
I found it: Fn + Shift + Option (Alt) + ←