R Ron de Bruin Apr 19, 2004 #2 Hi Hendy Do you mean empty rows between rows with data or rows at the bottem of your sheet
F Frank Kabel Apr 19, 2004 #3 Hi have a look at http://www.cpearson.com/excel/deleting.htm#DeleteBlankRows
K Ken Wright Apr 19, 2004 #4 If there is a single column that you can rely on to be able to say:- 'If the cell is this column is blank, then delete the row' then select that column and do Edit / Go To / Special / Blanks then Edit / Delete / Entire row
If there is a single column that you can rely on to be able to say:- 'If the cell is this column is blank, then delete the row' then select that column and do Edit / Go To / Special / Blanks then Edit / Delete / Entire row
