PDA

View Full Version : [SOLVED] Mac excel shortcut to select all rows till end



volabos
03-05-2017, 08:40 PM
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
03-07-2017, 12:28 PM
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