How to Use the Insert Option in Excel Home Tab

Have you ever entered data in Excel and then realised that you need an extra row or column in the middle of your worksheet?

You don’t need to move your existing data manually.

Excel has an Insert option that lets you add new cells, rows, columns, and worksheets quickly.

Let’s see how each option works.

Where Is the Insert Option in Excel?

The Insert command is available in the Cells group on the Home tab.

1. Click the Home tab on the Ribbon.

2. Look for the Cells group.

3. Click Insert.

You will see options such as:

• Insert Cells
• Insert Sheet Rows
• Insert Sheet Columns
• Insert Sheet

The options you see can also change when you are working inside an Excel Table.

Insert Cells:

The Insert Cells option lets you add new cells without inserting an entire row or column.

For example, suppose you have:

Product	Quantity	Price
Laptop	2	₹ 50,000
Mouse	5	₹ 800
Keyboard	3	₹ 1,200

1. Select the cell where you want to add cell.
2. On the Ribbon, click the Home tab.
3. In the Cells group, click Insert.
4. Click Insert Cells.
5. Excel will open the Insert dialog box.

You can choose:

• Shift cells right
• Shift cells down
• Entire row
• Entire column

After selecting an option, click OK.

For example, if you select cell B3 and choose Shift cells right, Excel adds a new empty cell in B3 and moves the existing B3 data to C3.

This is useful when you only need to create space in a particular area.

Tip: You can also select a cell and click the main Insert button. Excel will insert a new cell and move the existing data right, down, or in the appropriate direction based on the worksheet.

If you want to choose exactly how the existing cells should move, open the Insert dropdown and select Insert Cells. Excel will then let you choose Shift cells right, Shift cells down, Entire row, or Entire column.

Insert Sheet Rows:

Insert Sheet Rows adds a complete row above the selected row.

To insert a complete row:

1. Select a cell in the row where you want the new row.

2. Go to Home → Cells → Insert.

3. Click Insert Sheet Rows.

Excel will insert a new row above the selected row.

Example:

If you select Row 3 and click Insert Sheet Rows, Excel adds a new Row 3.

The old Row 3 data moves down to Row 4.

Tip: You don’t always need to open the Insert dropdown to add a row.

If you select the entire row by clicking the row number and click the main Insert button, Excel will insert a new row above the selected row.

Learn more: How to Add and Delete Rows in an Excel Worksheet

Insert Sheet Columns:

Insert Sheet Columns adds a complete column to the left of the selected column.

To insert a complete column:

1. Select a cell in the column where you want the new column.

2. Go to Home → Cells → Insert.

3. Click Insert Sheet Columns.

Excel inserts a new column to the left of the selected column.

Example:

If you select Column C and click Insert Sheet Columns, Excel adds a new Column C.

The old Column C moves to Column D.

Tip: You don’t always need to open the Insert dropdown to add a column.

If you select the entire column by clicking the column letter and click the main Insert button, Excel will insert a new column to the left of the selected column.

Learn more: How to Add and Delete Columns in Excel

Insert Sheet:

You can also add a new worksheet using the same Insert menu.

1. Go to Home → Cells → Insert.

2. Click Insert Sheet.

Excel will add a new worksheet to the workbook.

Learn more: How to Add and Delete Worksheets in Excel

What Happens When You Use Insert Inside an Excel Table?

The Insert command behaves differently when you click inside an Excel Table.

For example, suppose you have an Excel Table.

Tip: Select the data and press Ctrl + T to make the data into Table.

When you click inside the Table and use the Insert option, Excel provides Table-related options for adding rows or columns.

You may see options such as:

• Insert Cells
• Insert Sheet Rows
• Insert Sheet Columns
• Insert Table Rows Above
• Insert Table Rows Below
• Insert Table Columns to the Left
• Insert Table Columns to the Right
• Insert Sheet

The Table-specific options add a complete row or column to the Table.

For example, if you select a cell in the Mouse row and choose Table Rows Above, Excel adds a new row above Mouse as part of the Table.

Similarly, Table Columns to the Left adds a new column to the left of the selected Table column.

The new row or column automatically becomes part of the Table and follows the Table’s formatting and features.

Can You Insert a Single Cell Inside an Excel Table?

No. You cannot insert just one individual cell inside an Excel Table and shift only the surrounding cells.

For example, in a normal worksheet range, you can select B2, choose Insert Cells, and select Shift cells right. This moves only the cells in that area.

An Excel Table has a fixed row-and-column structure. When you try to add cell inside a Table, Excel adds a complete Table row or column instead.

Tip: If you are working inside an Excel Table, pay attention to the Insert options because Excel treats the Table differently from a normal worksheet range.

Insert Options at a Glance:

Insert Option	What It Does
Insert Cells	Adds cells and lets you shift existing cells right or down
Insert Sheet Rows	Adds a complete worksheet row
Insert Sheet Columns	Adds a complete worksheet column
Insert Sheet	Adds a new worksheet

Insert Options in an Excel Table:

Insert Option	What It Does
Insert Cells	Adds space by inserting a complete Table row or column, rather than a single cell.
Insert Sheet Rows	Adds a complete worksheet row above the selected row.
Insert Sheet Columns	Adds a complete worksheet column to the left of the selected column.
Insert Table Rows Above	Adds a new row above the selected row in an Excel Table.
Insert Table Rows Below	Adds a new row below the selected row in an Excel Table.
Insert Table Columns to the Left	Adds a new column to the left of the selected column in an Excel Table.
Insert Table Columns to the Right	Adds a new column to the right of the selected column in an Excel Table.
Insert Sheet	Adds a new worksheet to the workbook.

Final Thoughts:

The Insert option in the Cells group is a quick way to add new cells, rows, columns, and worksheets in Excel.

If you select the entire row by clicking the row number, or select the entire column by clicking the column letter, you can simply click the main Insert button. Excel will immediately insert a new row or column.

If you select any cell and open the Insert dropdown, you can choose Insert Sheet Rows or Insert Sheet Columns.

So, selecting the entire row or column lets you use the main Insert button directly, while selecting a cell gives you more options from the dropdown.

Similarly, when you select a cell and click the main Insert button, Excel can insert a new cell and move the existing data based on the worksheet.

If you want to choose exactly how the existing cells should move, open the Insert dropdown and select Insert Cells. Excel will then let you choose Shift cells right, Shift cells down, Entire row, or Entire column.

If you are working inside an Excel Table, the Insert options work differently and give you Table-specific choices.