Mac excel shortcut to select all rows till end

[volabos]

Hi,

I am using Excel on Mac and trying to select all Rows below a certain row number (say 100) till End of the Excel and then hide them. In Windows it is quite easy, however I couldnt find a way to do the same in Mac.

Appreciate if some expert here shed some light.

Thanks,

[volabos]

I was able to fix the problem through VBA route. The simple code which I have used is :

ThisWorkbook.Sheets("asas").Columns("M:XFD").EntireColumn.Hidden = True