To change the contents and layout of your worksheets, you ll often need to insert extra cells or delete existing cells. Excel provides keyboard shortcuts for both operations.
[Ctrl] - [-]
If you have one or more cells selected, Excel displays the Delete cells dialog box (shown here) so that you can specify in which direction to move the remaining cells. You can also choose to delete the row or column. If you press this shortcut with one or more rows or columns selected, Excel deletes the rows or columns without confirmation.
[Ctrl] - [Shift] - [+]
Excel displays the Insert cells dialog box (shown here) so that you can choose whether to move the other cells to the right or down. You can also choose to insert an entire row or column. If you press this shortcut with one or more rows or columns selected, Excel inserts the same number of rows or columns without displaying the Insert cells dialog box.