Thank you is hard to say? Use either shift left or up

--

Regards,

Peo Sjoblom

"Batman" wrote in message
...
I have four columns of data, some of the cells are blank, how do I delete
those particular rows?

"Peo Sjoblom" wrote:

Select the range, press F5, special and select blanks, press Ctrl and
minus
(dash), select entire row

--

Regards,

Peo Sjoblom


"Batman" wrote in message
...
How do I delete rows that contain blank cells in an Excel Worksheet?