Hiding columns and/or rows

Hi in the name box the one that displays the activecell address to the left of the formula bar type

2:5000

and press enter. This will highlight all the rows.

Do not click anywhere otherwise you will lose the highlight

To hide the rows either

Hold down the Ctrl key and press the number 9 = Ctrl+9 this is the shortcut key to hide rows

OR

Go to the Home tab select format -Hide and unhide - Hide Rows