What do you do when inserting rows and deleting ranges in Excel?

Answer 1

To insert rows, you select the row(s) where you want the new row(s) to go. You can even just select a cell in the row(s) you want. So if you wanted to insert 2 new rows between row 1 and row 2, you could select a cell in row 2 and row 3, or select both of those rows. Right click, and pick Insert and choose to insert an Entire row. The existing rows 2 and 3 will be pushed down to become rows 4 and 5, and 2 news rows will be in row 2 and row 3.

To delete a range, select the cells in the range. To delete the contents, press the Delete key. To get rid of the cells completely, right click and pick Delete on the shortcut menu. You can then choose to move the cells below up into the position where the range was, or move the cells to the right of them into the position of those cells.