Then, open the Home tab > from Editing group > go to Find & Select > finally select Go To SpecialĪ dialog box will pop up. You can use the Go To Special option to remove empty rows.įirst, select the rows to apply Go To Special. Read More: Delete Row If Cell is Blank in Excel (4 Methods) 4. Hold the CTRL key and select the row number. Then open the Home tab > from Delete group > select Delete Sheet RowsĪs a result, it will remove the empty row. To remove an empty row using ribbon, first, select the empty row or rows. In the ribbon, there has a Delete group where you can find the Delete Sheet Rows. Read More: How to Use VBA to Delete Empty Rows in Excel 3. Therefore, it will delete the selected empty rows. Now, Hold the CTRL key and press minus(-) You also can use the keyboard shortcut to delete empty rows.īefore removing the empty rows, select the empty row by left clicking on the mouse in the row number. Read More: How to Delete Empty Rows at Bottom in Excel (7 Ways) 2. Thus, it will delete the selected empty rows. Now, right click on the mouse then from the context menu select Delete. Hold the CTRL key and select the row number to select multiple rows. If you want to select multiple rows then you can use the CTRL key. You can remove one row or multiple rows at a time.įirst, select the empty row by left clicking on the mouse in the row number. You can use the context menu to remove empty rows using the Delete command.
0 Comments
Leave a Reply. |