How To Delete Empty Rows

Sometimes we get data which contains empty rows in between .Here is the shortcut to delete the empty Rows.



Step1 

Select all columns containing data.

Step 2

Click On Sort Icon [Goto DATA Tab -Sort (either Ascending or Descending)]







1 comment:

  1. This comment has been removed by a blog administrator.

    ReplyDelete