Excel remove empty rows tutorial - quickest way

Here's a quick tip on how to remove empty rows in Excel 2007 and 2010. The best way is to use filter tool and sort the data in any way you wish. This will move the empty rows to the end of the table.

1. Go to Data tab → sort and filter group and click on the filter.

Excel remove empty rows tutorial - quickest way


2. Click on any of the arrow symbols next to column titles and choose any sorting option you wish.
That's it. You are done.

Excel remove empty rows tutorial - quickest way

No comments:

Post a Comment