You can insert blank cells above or to the left of the active cell on a worksheet. When you insert blank cells, Excel shifts other cells in the same column down or cells in the same row to the right to accommodate the new cells. Similarly, you can insert rows above a selected row and columns to the left of a selected column. You can also delete cells, rows, and columns.
Note: Microsoft Excel has the following column and row limits: 16,384 columns wide by 1,048,576 rows tall.
Insert and delete rows, columns, and cells to organize your worksheet better.
Insert or delete a column
To insert a column, select the column, select Home > Insert > Insert Sheet Columns.
To delete a column, select the column, select Home > Insert > Delete Sheet Columns.
Or, right-click the top of the column, and then select Insert or Delete.
Insert or delete a row
To insert a row, select the row, select Home > Insert > Insert Sheet Rows.
To delete a row, select the row, select Home > Insert > Delete Sheet Rows.
Or, right-click the selected row, and then select Insert or Delete.
Insert a cell
Select one or more cells. Right-click and select Insert.
From the Insert box, select a row, column or cell to insert.
Do you have a specific function question?
Help us improve Excel
Do you have suggestions about how we can improve the next version of Excel? If so, please check out the topics at Excel User Voice.