In this tutorial we are going to look at how to quickly delete blank rows in Excel. This technique is useful if you have a large list with many blank rows to remove. It works equally well if you need to delete blank columns.
The tutorial given below shows you how to do it and as always there is a file underneath for you to practise on.
[flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/delete_blank_rows_and_columns.m4v’]
Here is the file for you to practise on. And you should now feel very comfortable with deleting blank rows (and columns in Excel). You can get the keyboard shortcuts for deleting rows and columns from the shortcut list that you get when you sign up