Inserting and Deleting Cells in an Existing Range

Sometimes, after building your spreadsheet, you have to modify its structure slightly by inserting new cells for additional entries in an existing range. To insert new cells without replacing the cells that already have existing entries, just use the Insert → Cells command and then indicate whether Excel is to shift the cells down or to the right to make room for the new blank ones.

Deleting cells from existing ranges when you don't want to leave empty cells is a similar process: You use the Edit → Delete command.