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.
Removing Blank Rows with Find & Select
- Click Find & Select.
- Click to Go to Special.
- Choose Blanks.
- Click OK and then all the blank rows/cells will be highlighted.
- Choose the Delete under Cells section on the Home Tab.
- Click Delete Sheet Rows.
In corporate life, many people sweat while working with various reports and data!
But if you master a little Excel skills, it is possible to do the work of hours in seconds and the work of days in minutes in many cases!
Remove Blank Rows in Excel
Tags
Blog