View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Jan Karel Pieterse Jan Karel Pieterse is offline
external usenet poster
 
Posts: 535
Default Deleting Multiple Blank Rows

Hi Diabolo,

Is there a quick and simple way of deleting multiple different blank rows
from a sheet? - Other than indivdually clicking on them (with ctrl) and then
deleting.

i.e. removing the blank rows between the other rows of data? (But on a large
scale)


You could sort the table?

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com