Excel Remove Blank rows - Simple to Advanced tips with Shortcuts and Conditional Formatting
Methods to remove blank rows in Excel data. This demonstration includes many shortcuts and several methods to remove those annoying blank rows.
There is a simple method when your data does not include blank cells, just blank rows. I then show you how to delete unwanted blank rows when you also have blank cells in your data. This uses advanced conditional formatting and advanced functions.