If you're insert three rows, pull it down three rows. Pull the fill handle down the same number of rows you want to insert.Be sure to select all of the contiguous cells - A4:D4. For instance, to insert a (partial) row between the last two records, you'd select the record in row 4. Select the cells above the area where you want to insert a partial row or rows.Now, let's look at one more method - the one using the fill handle: You’re probably familiar with some, if not all of the above methods. This shortcut will insert cells instead of entire rows and columns, if you don't select an entire row or column first. Press ++= to insert the appropriate number of rows or columns.Hold down the key and use the arrow keys to expand the selection.
If you prefer keyboard shortcuts, use the following steps to insert rows and columns: If inserting a single row or column, you can eliminate another step by simply right-clicking the row or column's header cell - no need to select anything first. To eliminate a few clicks, select the entire row (or column) by dragging over the header cells before right-clicking Excel will insert rows without displaying the Insert dialog. You can also right-click a selection, choose Insert, click the Entire Row (or Entire Column) option, and click OK.
