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