Hi Don & Tom,

I tried that, but it only gathered two or three blank rows and it's like 250
blank rows scattered throughout the workbook.

"Don Guillett" wrote:

You could select the column header desiredf5goto specialblanks

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Halston76" wrote in message
...
How do I delete all the blank rows throughout my workbook after unmerging
cells in Excel? There has to be a better way than scrolling through and
deleting each blank row. At least I hope there is :-)

Thanks