Deleting blank rows

Hi Lucy,

Thank you for the forum question.

Select the whole range with the mouse (including the blank rows and headings). On the data tab click sort ascending in the sort and filter group. Then the blank rows will be the last rows in the selection and easy to delete.

If you have some knowledge using VBA you can use the code below, but you will need to amend Range("a1:a2000"). If your list is B4:M200 change it to Range("b4:b200")

Sub DeleteBlankRows()

Range("a1:a2000").SpecialCells(xlCellTypeBlanks).EntireRow.Delete

End Sub



I hope this makes sense



Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector