Need to delete two or three rows in the same area on a spreadsheet?
Highlight the first row, then hold down theCtrlkey on your keyboard and snag the other rows.
This deletes only the row selected.
Fortunately, there’s an easy way to delete all your blank rows at one time.
In the worksheet where you want to delete rows, go to theHometab and selectFind & Selectfrom theEditinggroup.
In the menu that appears, selectGo to Special.
TheGo to Specialdialog box appears.
tap the radio button next toBlanksand then clickOK.
This will select all the blank rows in your spreadsheet.
Be careful when using this method to select blank rows.
With the rows selected, on theHometab, selectDeletefrom theCellsgroup.
From theDeletemenu, selectDelete Sheet Rows.
Alternatively, once the blank rows are selected, you could use the keyboard shortcutCtrl+-.
This opens aDeletedialog box, in which you should opt for radio button next toEntire rowand clickOK.
