On Wednesday, December 26, 2007 at 7:54:00 PM UTC+7, Satnam Randhawa wrote:
I have a worksheet with close to 100 rows out which 15-20 are hidden. How do
I unhide all the rows in one work sheet in one go without having to drag them
out individually?

Ctrl + Shift + 0 = to unhide the hidden columns within the selection
Ctrl + Shift + 9 = to unhide the hidden rows within the selection
Ctrl + 0 = to hide the selected columns
Ctrl + 9 = to hide the selected rows

Source:
http://gantt-chart-excel.com/how-to-...-in-excel.html