Adding or deleting rows/columns

Adding or deleting rows/columns to enhance the organisation of your worksheet.

Menu to adding or deleting rows/columns
© Lifewire, 2019.

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

  1. Choose any cell within the column, then go to Home > Insert > Insert Sheet Columns or Delete Sheet Columns.
  2. Another way is to right-click the top of the column, and then press Insert or Delete.

Add or delete a row

  1. Click any cell within the row, then go to Home > Insert > Insert Sheet Rows or Delete Sheet Rows.
  2. Otherwise, right-click the row number, and then choose Insert or Delete.

Formatting Options

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.

Image of the Insert Options button that's displayed after adding rows/columns.

If the Insert Option button doesn’t appear, then go to FileOptionsAdvanced in the Cut, copy and paste category, and then check the Show Insert Options buttons choice.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

See Also

Basic tasks in Excel

Overview of formulas in Excel

Leave a Reply

%d bloggers like this: