I have an excel spreadsheet sent to me that contains blank rows. Is there a
way to get rid of the blank rows with a formula so I don't have to go through
and delete. There are over 2000 rows with blanks inbetween each row of text.
Thanks,
If you set up Autofilters then you can filter one column for (blanks),
then highlight all the blank rows which are displayed (row identifier
turns blue) and Edit | Delete Row in one operation. Select (All) from
the filter pull-down list and all your blank rows will have gone.
Hope this helps.
Pete
way to get rid of the blank rows with a formula so I don't have to go through
and delete. There are over 2000 rows with blanks inbetween each row of text.
Thanks,
If you set up Autofilters then you can filter one column for (blanks),
then highlight all the blank rows which are displayed (row identifier
turns blue) and Edit | Delete Row in one operation. Select (All) from
the filter pull-down list and all your blank rows will have gone.
Hope this helps.
Pete
文章標籤
全站熱搜
