Step 5: As you can see in the picture below it has also delete those rows which have some column entry remaining. It will show some delete options among them click the Delete Sheet Rows. Step 4: Now, to delete the blank rows click the Delete dropdown menu under Cells group of Home tab. Step 3: The above step would highlight all the blank cells in the table and automatically it highlights the entire blank rows also. Here, under the Select section, you have to select Blanks and click OK. Step 2: A Go To Special dialog box will pop out. from Find & Select dropdown menu in the Editing group of Home tab. Step 1: Select the entire table and click Go To Special…. Note: Do not use this method to delete blank rows as this also deletes the rows which have some column entries remaining. Steps to Delete Blank Rows in Excel 2016: And now, you have to delete blank rows but how? Well, if you are working with a large table in Excel and you keep on adding or removing entries in a table, definitely there will be blank cells or entire blank rows created in the table. So, to clean the data in the table we must delete blank rows present in a table that creates a disturbance while analysing the data. Blank rows or cells in a table create a lot of confusion for excel built-in functions to identify the data in a correct manner.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |