Insert Multiple Columns in Google Sheets

Adding several columns at once in Google Sheets saves you from repeated right-clicks and keeps your data organized in one step. This guide shows you the fastest ways to insert two, five, or fifty new columns anywhere in your spreadsheet, whether you’re working on a desktop browser or the mobile app.

What You’ll Need

A Google account and access to a Google Sheets spreadsheet (web or mobile app).
Edit permissions for the sheet (you must be the owner or have edit access).
Decide where you want the new columns to appearâ€”they will be inserted to the left of the column(s) you select.

Step-by-Step

Method 1: Insert Multiple Adjacent Columns (Desktop)

Open your Google Sheets file in a web browser (Chrome, Firefox, Safari, etc.).
Click on the letter header of the first column where you want the new columns to go. For example, if you want to add columns before column C, click on the “C” header.
To select multiple columns, hold the Shift key and click the header of the last column in the range. For instance, to insert 3 columns before C, select columns C, D, and E (click C, then Shift+click E). The selected headers will be highlighted.
Right-click on any of the highlighted column headers.
From the context menu, choose Insert 3 columns left (the number will match how many columns you selected). Google Sheets inserts that many new columns to the left of your selection.
If you need more or fewer columns, adjust your selection before right-clicking. Alternatively, use the menu at the top: Insert â†’ Columns â†’ Insert 3 columns left (or right, depending on your selection).

Method 2: Insert Non-Adjacent Columns (Desktop)

Hold the Ctrl key (or Cmd on Mac) and click on the headers of the specific columns where you want to add new ones. For example, click B, then Ctrl+click D to select both.
Right-click on one of the selected headers.
Choose Insert 1 column left (or right) for each selected column. Google Sheets will insert one new column next to each selected column, effectively adding multiple columns in different locations at once.

Method 3: Insert Many Columns at the End (Desktop)

Go to the far right of your sheet. Find the last column that contains data (or the last column you want to extend).
Click on the header of that last column (e.g., column Z).
Hold Shift and press the Right Arrow key repeatedly to select additional empty columns to the right. You can also drag the selection handle (the blue square at the bottom-right of the header) to the right.
Right-click on any selected header and choose Insert X columns right (X will be the number you selected).

Method 4: Using the Mobile App (Android/iPhone)

Open the Google Sheets app on your phone or tablet.
Tap on the column letter header (e.g., “B”) to select that column. A small menu appears.
To select multiple columns, tap and drag the blue handles that appear on the edges of the highlighted column to extend the selection left or right.
Tap the Insert icon (usually a plus sign or a grid with a plus) in the toolbar that appears at the bottom or top.
Choose Insert columns left or right. The number of columns you selected will be inserted.

Common Mistakes

Selecting the wrong number of columns: The number of new columns inserted equals the number of columns you selected. If you need 5 columns, you must select 5 existing columns first.
Inserting to the wrong side: The default is to insert left of your selection. If you want columns to the right, you must choose the “right” option from the menu.
Selecting non-adjacent columns and expecting a single block: If you Ctrl+click columns B and D, you’ll get two separate new columns, one next to each, not a single block of two columns.
Forgetting to select the header: If you click on a cell (like B2) instead of the column letter, the insert option will be grayed out or will insert rows instead.

Tips

Use keyboard shortcuts: On desktop, after selecting columns, press Ctrl+Alt+Shift+Left Arrow (Windows/ChromeOS) or Cmd+Option+Shift+Left Arrow (Mac) to insert columns to the left. For right, use the Right Arrow key.
Insert columns without breaking formulas: Google Sheets automatically updates cell references in formulas when you insert columns, so your calculations remain correct.
Use the “Insert” menu for exact numbers: If you need a specific number of columns, select that many, then use the menu Insert â†’ Columns and it will show the exact count.
Copy formatting: If you want the new columns to match the formatting of existing ones, select the columns next to where you’re inserting, copy (Ctrl+C), then paste special (Ctrl+Shift+V) into the new columns, or use the paint format tool.

Troubleshooting

Insert option is grayed out: This usually means you haven’t selected a column header, or you’re in a protected range. Check that you have edit permissions and that the sheet isn’t protected (Data â†’ Protect sheets and ranges).
Columns insert but data shifts unexpectedly: If you have merged cells or filters, inserting columns can sometimes cause alignment issues. Unmerge cells or clear filters before inserting if this happens.
Mobile app doesn’t show the insert option: Make sure you’ve selected the entire column (tap the letter). If you only selected a cell, the insert option may not appear. Also, ensure the app is updated.
I selected 5 columns but only 1 was inserted: This can happen if you used the “Insert 1 column left” option from the right-click menu instead of the “Insert 5 columns left” option. Double-check the menu text before clicking.
New columns appear but are blank and unformatted: That’s normalâ€”new columns inherit the default formatting. Use the paint format tool to copy formatting from an adjacent column if needed.

Frequently Asked Questions

Can I insert multiple non-adjacent columns at once?

Yes, on desktop you can Ctrl+click (Cmd on Mac) on multiple column letters, then right-click and choose “Insert 1 column left” (or right). This will add one column next to each selected column, not a single block.

What’s the maximum number of columns I can insert at once?

Google Sheets has a limit of 18,278 columns per sheet. You can insert as many as you want as long as you don’t exceed that total. If you try to select more than that, the insert option will be disabled.

Will inserting columns mess up my formulas?

No, Google Sheets automatically adjusts cell references in formulas when you insert columns. For example, if a formula references A1 and you insert a column before A, the reference becomes B1.

How do I insert columns at the very end of the sheet?

Select the last column that contains data (or the last column you want to extend), then hold Shift and press the Right Arrow key to select additional empty columns. Right-click and choose “Insert X columns right.”

Is there a way to insert multiple columns using a script or add-on?

Yes, you can use Google Apps Script to write a custom function that inserts a specified number of columns. There are also add-ons in the Google Workspace Marketplace that offer bulk column insertion, but the built-in method is usually sufficient.

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

Make sure you tap the column letter (e.g., “A”) to select the entire column. If you only tap a cell, the insert option may not show. Also, check that you have edit access to the sheet.

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 →