What often happens when I want to delete a row in Microsoft Excel is that I instinctively hit the delete key. But that only clears the cell contents without deleting the entire row from the spreadsheet. So I finally found the proper keyboard shortcuts for deleting (and adding) rows in Excel. The shortcut keys will also work the same for adding and deleting columns.
Once you have the desired rows selected, you just need to hit CTRL- (the control key and the minus key) in order to delete the selected rows (or columns). CTRL+ (the control key and the + key) will do the opposite and add a row or column It’s easiest to use the number pad as you’ll need to hold down the shift key to access the + key on the main keyboard.
Another timesaver: you don’t need to actually “select” the entire row or column to get rid of it. If you don’t have your desired row entirely selected, just press SHIFT SPACE (the shift key and the space key) to select whatever rows correspond to the selected cells. Selecting columns is done by using the CTRL SPACE key combination.