1

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.

How on Excel 2011 (Mac) 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.

1

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

0

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

-1

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 '18 at 13:39

You must log in to answer this question.

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