How can I delete empty rows in Excel?
How to remove blank rows in Excel
- Click the Home tab in the top menu bar in Excel, and click “Find & Select” on the right side.
- Select “Go to Special.”
- A pop-up box will appear.
- Excel will then highlight all of the blank cells.
- Once all the blank rows are highlighted, go to the Home tab and find the “Delete” button on the right-hand side.
What is the shortcut to remove blank rows in Excel?
Select all the filtered rows: Press Ctrl + Home, then press the down-arrow key to go to the first data row, then press Ctrl + Shift + End. Right-click on any selected cell and choose “Delete row” from the context menu or just press Ctrl + – (minus sign). Click OK in the “Delete entire sheet row?” dialog box.
How do I delete blank rows in Excel without sorting?
A quick way to delete blank rows in Excel
- Press [F5].
- In the resulting Go To dialog box, click Special.
- Click the Blanks option and click OK. Doing so selects the blank cells (what you might think of as rows) in the selected range.
- Now you’re ready to delete the selected cells.
- Excel will delete the blank cells from the selected data range.