How do I remove rows from an Excel page

10 pts.
Tags:
Microsoft Excel
I have an Excel spread sheet with a lot of data. However, between the rows with the data there are many rows that are empty. I want to remove the rows to make the data more compact looking. How do I remove them? There are too many pages for me to take the time to delete them one by one. Can anyone help? Thank you.

Software/Hardware used:
Excel

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Ketan19
    Hi, Apply Filter & then select only Blank rows. Then you can delete them easily. Regards, Ketan
    305 pointsBadges:
    report
  • Nosugar
    Another way would be to insert a column in front of column A. Then fill the column with values from 1 to the last row of data; including blank rows. Next select the range that includes every row and column populated. Now sort your data on a column that contains data in every row. At this point all the blank rows should be grouped at the top of the sheet. Delete the blank rows and the re-sort your data on column A (the column you inserted.) good luck, David
    235 pointsBadges:
    report
  • WB123
    Re suggestion to apply filter then delete blank rows, won't work as will only show filtered data up to the row before the first blank row. David's suggestion will work or you could do a combination of Ketan and David's suggestion by inserting a new column (A), populating every row from the first row of data to the last row of data, doesn't matter what you put in it as long as every row which has your data alongside it is populated. Then apply filtering as Ketan suggested, the fact you have at least one column fully populated will now include all rows from first to last in the filtering operation, select blank rows then delete them. Once done delete column A, do this for each sheet in the workbook.
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following