Note this trick actually deletes blank rows below the data as well, so be sure you don't have important information below the data. Now if I move to the bottom of the data, you can see that we just have about 33000 rows remaining. When I click OK, all blank rows are completely removed. Now use Control minus to delete, and choose Entire row. Then Special, then select Blanks.Īt this point, every blank cell in column A is selected. Then select the column, and use Ctrl + G for Go To. In this case, Column A should always have a name. First, pick a column that should always contain data. To quickly remove these blank rows, I can use Go To Special. If I move to the last cell, you can see that there's over 36,000 rows of data, and, looking at the count, just over 33,000 rows actually contain data, which means over 3000 rows are blank. How to use shortcut keys to insert or delete row/column/tab in Excel. Insert or Delete a Row or Column in Microsoft Excel. Delete Row in Excel Shortcut Keyboard Shortcut to Delete a Row. In this first example, we have a big set of data that contains a lot of blank rows. How to Quickly and Easily Delete Blank Rows and Columns in Excel. In this video, we'll look at a shortcut recipe that lets you easily remove hundreds or thousands of blank rows in a worksheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |