I'm trying to figure out a way of deleting all the hidden rows on a spreadsheet. Whats the best away about doing this? Is there anyway I can select just hidden rows? There are hundreds, and doing this manually would take FOREVER.

I'm doing this as I need to perform a mail merge on the data, the guy that produced the excel spreadsheet hid the rows of those not required instead of deleting them.

I'm using Office 2003.

Cheers,

Toby