How To Delete All Blank Rows In Excel
We all want to Delete All Blank Rows in Excel together at some point or the other but there is no excel formula or function to delete all empty rows together.
However we can delete all blank rows in excel with these steps
1 Create a helper on the right hand side of the data
2 Use the Counta Formula in that Helper column to count the non empty cells in each rows
3 Any Row which will be blank will show the Counta result as 0
4 Apply Filter and select rows with 0 value
5 select these rows together and delete these rows 🙂
** Useful Excel formulas and Functions **
10 Most Used Formulas MS Excel
Learn Basic Excel Skills For Beginners || Part 1
10 Most Used Excel Formula
**Most Imporant Excel Formuls Tutorials**
Learn Vlookup Formula For Beginners in Excel
5 Excel Questions Asked in Job Interviews
Create Speedometer Chart In Excel
Learn the Basic of Excel for Beginners || Part 2
Create Pareto Chart In Excel
How to Create Dashboard in Excel
Excel Interview Questions & Answers
To watch more videos and download the files visit http://www.myelesson.org
To Buy The Full Excel Course visit . http://www.myelesson.org/product or call 9752003788
Connect with us on Facebook – https://www.facebook.com/excelmadeasy/
Connect with us on Twitter – https://twitter.com/Excelmadeasy