Adding or deleting rows/columns to enhance the organisation of your worksheet.
Applies to: Excel for Microsoft 365, Excel for the web, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007.
Note: Microsoft Excel has the following column and row limits: 16,384 columns wide by 1,048,576 rows tall.
Add or delete a column
- Choose any cell within the column, then go to Home > Insert > Insert Sheet Columns or Delete Sheet Columns.
- Another way is to right-click the top of the column, and then press Insert or Delete.
Add or delete a row
- Click any cell within the row, then go to Home > Insert > Insert Sheet Rows or Delete Sheet Rows.
- Otherwise, right-click the row number, and then choose Insert or Delete.
When you choose a row or column with pre-existing formatting, such formatting will be transposed to a new row or column that you add.
If the Insert Option button doesn’t appear, then go to File > Options > Advanced in the Cut, copy and paste category, and then check the Show Insert Options buttons choice.