www.xlninja.com/2012/07/10/how... Often you will receive a spreadsheet with information organised in a table but with blank rows. How do you delete blank rows in Excel quickly and easily?
Just watched your video in 2024, Apr 14th! Thank you Gentleman! always wanted to do this but a bit lazy to Google it up and watch any videos finally happy that I got what I wanted in the first youtube video itself!
This is really helpful but won't this also delete rows even if only one of the cells in the row is blank? If you have information in all of the cells but one, it would still delete the entire row, data and all wouldn't it?