Excel Video 276 Finding and Deleting Blank Rows

If you’re getting extra blank rows when you download data from your software, you’re five clicks away from a solution in Excel Video 276. You’re getting used to quick shortcuts using Go To Special, so you won’t be surprised that we can do this shortcut in just five clicks. Today we’ll use Go To Special to select all of the blank rows in your data. You can find, select, and delete those blank rows in just five clicks. This can be a real timesaver if you have a lot of data or if you frequently download data with blank rows. The next shortcut takes more than five clicks, but it’s another big timesaver. Stay tuned.