Am I the only one who faces this? At work on my windows machine whenever I want to work on a copy of an excel (office 2008) page I just do ctrl-A, ctrl-C, select a blank tab and then ctrl-P. On my mac ...
You can hide and unhide rows in Excel by right-clicking, or reveal all hidden rows using the "Format" option in the "Home" tab.