How to delete blank rows from excel

Please find the attached excel for reference, I want to delete the blank rows from the sheet. Can anyone help with this?test.xlsx (44.9 KB)

Not working.

You can remove blank rows in Excel by first doing a “Find & Select” of blank rows in the document. You can then delete them all at once using the “Delete” button on the Home tab.

Double check that you’re only deleting the rows that you want, as selecting and deleting individual cells will move the data below it up, potentially disrupting the workflow of your Excel sheet.

Try this:

  1. Click the Home tab in the top menu bar in Excel, and click “Find & Select” on the right side.
  2. Select “Go to Special.”
  3. A pop-up box will appear. Select “Blanks,” and then hit “OK.”
  4. Excel will then highlight all of the blank cells. Before you delete the blank cells, ensure that only the cells that you want to remove are highlighted. If you just want to remove rows and not individual blank cells, you can always select a cell with “control + click” on a PC, or “command + click” on a Mac, to deselect it. Note that when you delete cells, the data below it will be moved up.
  5. Once all the blank rows are highlighted, go to the Home tab and find the “Delete” button on the right-hand side. Select “Delete Sheet Rows.” This will remove the blank rows.

Hope this works for you.

Regards,
Jerry M.