To remove empty rows between data

There are many ways to remove empty rows from table. One way I prefer is by moving all empty rows to bottom by using sort.

To remove empty rows between data:

1. Select all columns containing data by pressing Ctrl+Shift+End.

2. Click the Sort icon under Data menu(Office 2003 or below) (either Ascending or Descending).

As the purpose of this blog is to train/help all MS Excel users. You will find all the examples from basic to advance. Thanks for spending time in reading this post. Do leave valuable comments

 

Subscription is free here. Click here to subscribe