Insert new cells, rows, or columns

ShowInsert cells

When you insert blank cells, you can choose whether to shift other cells down or to the right to accommodate the new cells. Cell references (cell reference: The set of coordinates that a cell occupies on a sheet. For example, the reference of the cell that appears at the intersection of column B and row 3 is B3.) automatically adjust to match the location of the shifted cells.

  1. Select the cell, or the range of cells, to the right or above where you want to insert additional cells.

 Note   Select the same number of cells as you want to insert. For example, to insert five blank cells, select five cells.

  1. Hold down CTRL, click the selected cells, then on the pop-up menu, click Insert.
  2. On the Insert menu, select whether to shift the selected cells down or to the right of the newly inserted cells.
    Insert cells shift right
Action that occurs when you shift cells right.

Insert cells shift down

Action that occurs when you shift cells down.

 Tip   To insert cells that contain data, see Move or copy cells, rows, or columns.

ShowInsert rows or columns

When you insert additional rows or columns, they appear above or to the left of the selected cell on your sheet. Cell references (cell reference: The set of coordinates that a cell occupies on a sheet. For example, the reference of the cell that appears at the intersection of column B and row 3 is B3.) automatically adjust to match the location of the shifted cells.

  1. Select the heading of the row above where you want to insert additional rows; likewise, select the heading of the column to the right of which you want to insert additional columns.

 Note   Select the same number of rows or columns as you want to insert. For example, to insert five blank rows, select five rows. It’s okay if the rows contain data, because it will insert the rows above these rows. If you’re inserting columns, it will insert them to the left.

  1. Hold down CTRL, click the selected rows or columns, then on the pop-up menu, click Insert.

 Tip   To insert rows or columns that contain data, see Move or copy cells, rows, or columns.

See also

Delete cells, rows, or columns

Insert or delete sheets

 
 
Applies to:
Excel for Mac 2011