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.

  • I'm shocked it has been over 6 years and there is still no solution to this.
    – Ryan
    Apr 14, 2020 at 5:36

3 Answers 3


I found it: Fn + Shift + Option (Alt) +

  • Unfortunately, this doesn't work for me.
    – Ryan
    Apr 14, 2020 at 5:35

"Command" "Shift" "Arrow" on Mac can do the same as "Ctrl" "Shift" "Arrow" on PC.


On my Mac the shortcut is ctrl+shift+dirKey OR cmd+shift+dirKey MBP 2017. //Permki

  • Welcome to Ask Different. This answer has no context because you don't state the type or year of Mac you have. See How to Answer for info on how to provide good answers. Then, you can edit your answer to add the missing info. - From Review
    – fsb
    Apr 18, 2018 at 13:39

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .