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
- Open your spreadsheet and click a column header
- Right-click the header to open the context menu
- Choose Insert 1 column left or Insert 1 column right
- Select multiple headers to insert several columns at once
- Use the Insert menu as an alternative method
- Apply a keyboard shortcut for faster insertion
- Check that new columns appear in the correct spot
Interactive 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
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.
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.
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.
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.
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.
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.
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.
Related guides
Continue with more step-by-step guides for getting work done.
How to merge cells in Google SheetsLearn how to merge cells in Google Sheets horizontally, vertically, or all at once, plus how to unmerge and avoid data loss.
How to freeze rows in Google SheetsLearn how to freeze rows in Google Sheets so headers stay visible while scrolling, plus how to adjust or remove frozen rows.
How to sort a table A–Z in Google SheetsSort a table in Google Sheets A to Z or by several columns without scrambling rows. Keep the header in place, or sort with a formula instead.
How to add an X axis in Google SheetsAdd and label the X axis on a Google Sheets chart from the Chart editor's Customize tab: set the axis title, then style its labels. Interactive demo included.
How to connect Google Forms to Google SheetsStep-by-step guide to connecting Google Forms responses to a Google Sheets spreadsheet, including creating a form directly from an existing sheet.
How to convert CSV to Google SheetsLearn how to convert a CSV file to Google Sheets format, preserve your column structure, and save it as a native Sheets file.
Create interactive demos like this one — free, no coding required.
Start for free →