How to add columns in Google Sheets

Learn how to insert one or multiple columns in Google Sheets using right-click menus, the Insert menu, or a keyboard shortcut.

Quick answer

To add a column in Google Sheets, right-click a column header and select Insert 1 column left or Insert 1 column right. To add multiple columns, select several column headers first, then right-click and choose Insert [number] columns left or right. You can also use the Insert menu or keyboard shortcuts for faster column insertion.

Steps at a glance

  1. Open your spreadsheet and click a column header
  2. Right-click the header to open the context menu
  3. Choose Insert 1 column left or Insert 1 column right
  4. Select multiple headers to insert several columns at once
  5. Use the Insert menu as an alternative method
  6. Apply a keyboard shortcut for faster insertion
  7. Check that new columns appear in the correct spot

Interactive demo

Loading demo…

Summary

Adding columns in Google Sheets lets you expand a dataset without rebuilding your spreadsheet from scratch. Whether you need one extra column for a new data point or several at once, Sheets offers menu-based and keyboard shortcut methods that work on desktop.

Step-by-step guide

  1. Step 1

    Open your spreadsheet

    Go to Google Sheets and open the spreadsheet where you want to add a column. Sheets keeps the rest of your data in place.

  2. Step 2

    Select the column next to where you want to insert

    Click the letter header of the column that sits next to where your new column should appear. This selects the entire column and tells Sheets where to place the new one relative to it.

  3. Step 3

    Right-click and choose an insert option

    Right-click the selected column header to open the context menu. Choose Insert 1 column left to add a column before your selection, or Insert 1 column right to add one after it.

  4. Step 4

    Select multiple columns to insert several at once

    To add more than one column, click and drag across multiple column headers. Right-click the highlighted selection and choose Insert [number] columns left or right, where the number matches how many headers you selected.

  5. Step 5

    Use the Insert menu as an alternative

    With a column selected, click Insert in the top menu bar, hover over Columns, then choose Insert 1 column left or Insert 1 column right. This achieves the same result as right-clicking and is useful if you prefer working from the main toolbar.

  6. Step 6

    Apply a keyboard shortcut for speed

    Select a column, then press Cmd + Option + = on Mac. It inserts a column to the left of your selection. This shortcut works well once you're comfortable with the column layout and want to skip the menus.

  7. Step 7

    Adjust formatting and check your data

    Use the Format menu to style the new column, and review widths, borders, and text alignment. If your new column contains long entries, consider wrap-text so content stays readable without expanding the column too far, and use freeze-rows if you need headers to stay visible while you fill in new data.

Why this matters

You're mid-project and realize your spreadsheet needs an extra field — maybe a date, a status, or a calculation column your team requested. Knowing how to insert columns quickly, without disturbing existing formulas or formatting, keeps shared spreadsheets clean and lets collaborators trust the structure you've built.

Frequently asked questions

  • Can I add multiple columns in Google Sheets at the same time?

    Yes. Select the same number of columns as you want to add by clicking and dragging across headers, then right-click and choose Insert [number] columns left or right. Sheets inserts that exact number of new columns next to your selection.

  • Is there a keyboard shortcut to add a column?

    Yes. Select a column and press Cmd + Option + = on Mac, which inserts a column to the left of your selection without needing to right-click.

  • Will adding a column affect shared collaborators' view?

    Yes, anyone with edit access to the spreadsheet will see the new column. If you're working with a shared spreadsheet, it's a good idea to confirm structural changes with collaborators or check share-edit-access permissions before inserting columns others depend on.

  • Can I add columns using the Google Sheets mobile app?

    The steps in this guide cover Google Sheets in a desktop browser. The mobile app uses touch menus that differ from the desktop right-click menu, so check the app's own help for its exact labels.

Create interactive demos like this one — free, no coding required.

Start for free →