How to Insert Columns and Rows in Excel (Mobile, Desktop, Web)

Inserting columns and rows in Microsoft Excel is a fundamental task that keeps your data organized and your formulas accurate. Whether you’re working on a desktop PC, a mobile device, or in the web browser, the process is straightforward once you know the right clicks and taps. This guide covers all three platforms, showing you the exact steps for each, plus common pitfalls and troubleshooting tips.

What You’ll Need

A Microsoft Excel file (either an existing workbook or a new one).
For desktop and web: a mouse or trackpad, and a keyboard (optional but helpful for shortcuts).
For mobile: the Excel app installed on your iOS or Android device.
An internet connection if you are using Excel on the web (though desktop and mobile apps can work offline).

Step-by-Step

On Desktop (Windows or Mac)

Open your workbook in the Excel desktop application.
Select the column or row where you want the new one to appear. Click the letter at the top of a column (e.g., “C”) or the number on the left of a row (e.g., “5”). This selects the entire column or row.
Right-click the selected column letter or row number. A context menu appears.
Choose “Insert” from the menu. Excel immediately adds a new column to the left of the selected column, or a new row above the selected row. The existing data shifts to make room.
Alternative method: With a cell selected, go to the Home tab on the ribbon, click the Insert dropdown (usually near the Cells group), and select Insert Sheet Columns or Insert Sheet Rows.
Keyboard shortcut: Select a column or row, then press Ctrl + Shift + + (Windows) or Cmd + Shift + + (Mac). This inserts a new column or row without needing the right-click menu.

On Excel for the Web (Browser)

Open your workbook in a browser (e.g., Chrome, Edge, Safari) at office.com or through your OneDrive/SharePoint.
Select the column or row by clicking its letter or number, just like on desktop.
Right-click the selection. In the context menu, choose Insert. A new column or row is added instantly.
Using the ribbon: With a cell selected, go to the Home tab, click the Insert button (not the dropdown), and choose Insert Sheet Columns or Insert Sheet Rows.
Note: The web version does not support the Ctrl+Shift++ shortcut in all browsers; the right-click method is the most reliable.

On Excel Mobile (iOS and Android)

Open the Excel app on your phone or tablet and load the workbook.
Tap to select a cell in the column or row where you want to insert. For a column, tap any cell in that column; for a row, tap any cell in that row.
Tap and hold the selected cell until a context menu appears (or tap the three-dot “More” menu at the bottom).
Choose “Insert” from the menu. You will see options like Insert Columns or Insert Rows. Tap the one you need.
Alternative: On the ribbon, tap the Home tab, then tap Insert (the icon with a plus sign). Select Columns or Rows.
Note: On phones, the screen is small, so you may need to scroll through the menu options. The inserted column goes to the left, and the row goes above.

Common Mistakes

Selecting a range instead of a full column/row: If you select only a few cells (e.g., C2:C5) and insert, Excel may only insert cells within that range, shifting data awkwardly. Always select the entire column or row.
Inserting multiple columns/rows incorrectly: To insert several at once, select the same number of existing columns/rows as you want to add. For example, select three columns to insert three new ones. If you select just one, you only get one.
Breaking formulas: When you insert a column or row, Excel automatically adjusts most formulas. But if a formula references a specific cell range that you intended to stay fixed, inserting can change the range. Double-check formulas after inserting.
Inserting on a protected sheet: If the sheet is protected, the Insert option may be greyed out. You need to unprotect the sheet first (Review tab > Unprotect Sheet).

Tips

Use the quick access toolbar: On desktop, you can add the “Insert” command to the Quick Access Toolbar for one-click access. Right-click the Insert button on the ribbon and choose “Add to Quick Access Toolbar.”
Keyboard shortcuts save time: On desktop, Ctrl+Shift++ (or Cmd+Shift++) is the fastest way. On Mac, you can also use Ctrl+I after selecting a row/column.
Insert multiple at once: Select several columns or rows (e.g., drag across the letters) and then right-click and choose Insert. Excel adds the same number of new columns/rows.
Use the “Insert Options” button: After inserting, a small icon appears near the new column/row. Click it to format the new cells like the ones above/below or left/right.
On mobile, use the ribbon: The Insert menu is under the Home tab, but you can also long-press a cell to get a quick menu.

Troubleshooting

Insert option is greyed out: This usually means the sheet is protected. Go to the Review tab and select “Unprotect Sheet.” If you don’t know the password, you’ll need to ask the workbook owner.
New column/row doesn’t appear: Check if you are in “Page Layout” view. Sometimes the insert happens but is off-screen. Scroll to the right or down to see it. Also, ensure you are not in a merged cell that spans the entire column.
Formulas return errors after inserting: Excel usually adjusts formulas, but if you have a formula that references a range like A1:A10 and you insert a row at row 5, the range becomes A1:A11. If this is not intended, adjust the formula manually.
On mobile, the Insert menu doesn’t show: Make sure you have selected a cell first. If you tap on a blank area outside the grid, the menu may not appear. Tap on any cell, then long-press to get the context menu.
Web version is slow or unresponsive: Close other browser tabs and refresh the page. If the problem persists, try a different browser or clear your cache.

Frequently Asked Questions

Can I insert multiple columns or rows at once?

Yes. Select the same number of existing columns or rows as you want to add (e.g., select 3 columns to insert 3 new columns), then right-click and choose Insert. This works on desktop, web, and mobile (on mobile, tap the selection handle to extend the selection).

Will inserting a column or row mess up my formulas?

Excel automatically adjusts most formulas when you insert, so references shift to include the new cells. However, formulas that use indirect references or that are written as text (e.g., in a formula bar) may not update. Always check formulas that reference entire columns or rows.

How do I insert a column without affecting the adjacent data?

When you insert a column, Excel shifts the existing columns to the right, so the data in the adjacent column moves over. To avoid affecting data, insert the column at the far right of your data or copy the data to a new sheet first.

Is there a way to insert a row at the bottom of a table quickly?

Yes. Click on the last cell in the table, then press the Tab key. This adds a new row to the table. Alternatively, you can use the “Insert” menu and choose “Table Rows Above” or “Table Rows Below” if you are working with a formatted Excel table.

Why does the Insert option not appear on my mobile app?

Make sure you have selected a cell first. On iPhone, tap the cell, then tap the “More” (three dots) icon at the bottom. On Android, long-press the cell to bring up the context menu. If the option is still missing, try updating the app.

Can I undo an insert if I make a mistake?

Yes, press Ctrl+Z (or Cmd+Z on Mac) immediately after inserting. On mobile, tap the Undo arrow at the top of the screen. This will remove the inserted column or row and restore your data.

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →