How to delete blank rows in excel shortcut?
How to remove empty rows in excel at the bottom and in between rows. I have thousands of rows and hundreds of blank spaces and I want to remove all those blank rows. How do I delete those empty rows from my excel workbook? Is there any formula or shortcut to do this job?
How to delete empty rows in Excel
Step 1: Select the column first on which basis you want to delete rows
Steps 2: On HOME tab go to the last option Find & Select
Step 3: Click on Go To Special…
Step 4: Select Blanks option
Step 5: Find the Delete ▷ option and click on down menu and select Delete Sheet Rows.
That’s it. DONE. You will get the results like below-
All respected columns will also be deleted. I hope this has helped you. Please upvote this if you find this answer helpful.
Your guide was really helpful for me. No tricky ideas or complex formulas, even a non-technical person could implement it easily. Screenshots helped me a lot to understand easily.