Deleting hidden rows

[Tobeman]

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

[Ruthki]

You can select visible cells only and copy to another sheet

Use function key 5 (go to) and select special, you then have an option to select all visible cells. Once selected you can copy and paste the cells you want to another sheet and set that up for your merge.

R

[Tobeman]

Omg, I love you :D