How to delete empty rows in Excel (inc keyboard shortcut)

Learn super easy ways to quickly delete empty rows in Excel. If you need to quickly remove blank rows between your data, this tutorial will save you huge amounts of time.

Timestamps:
00:00 How to delete empty rows in Excel
01:01 Delete a single row
01:09 Delete multiple adjacent and non-adjacent rows (if you only have a few to delete)
01:26 Using keyboard shortcuts to delete rows
01:56 Delete multiple non-adjacent rows using Filter (perfect if you have MANY rows to delete)
03:06 Selecting multiple non-adjacent rows and then deleting them

❔ Need to remove empty rows at the end of your data? ✔ Check out the steps in our blog post: excelatwork.co.nz/2021/05/26/remove-empty-rows-…

Topic #14 and #51 in the ‘Steps to becoming Proficient in Excel’ workbook.

🔔 Become an Excel at Work Insider (100% free) and grab your copy of the ‘Steps to becoming Proficient in Excel’ workbook today: excelatwork.co.nz/subscribe/ 🔔

❤ VERSION FRIENDLY ❤
Try this with Excel 2010, Excel 2013, Excel 2016, Excel 2019 and Excel for Microsoft 365 (a.k.a Office 365). Sharyn’s using the desktop version of Excel for Microsoft 365 as part of the Microsoft 365 Business Standard subscription.

#ExcelTutorial #ExcelTips #ExcelBeginner #ExcelatWork