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 keyboard shortcuts on any device.
Quick answer
To add a column in Google Sheets, right-click a column header and select Insert 1 left or Insert 1 right. To add multiple columns, select several column headers first, then right-click and choose Insert columns. 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 left or Insert 1 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
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 the same way on desktop and adapt slightly on mobile.
Step-by-step guide
Step 1
Open your spreadsheet
Go to Google Sheets and open the spreadsheet where you want to add a column. If you're starting from a CSV or Excel file, you can first import CSV data or convert CSV to Sheets format before making structural changes.
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 left to add a column before your selection, or Insert 1 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, or hold Ctrl (Windows) or Cmd (Mac) while clicking individual headers. Right-click the highlighted selection and choose Insert [number] columns, 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 left or Insert 1 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 Ctrl + Alt + = on Windows or Cmd + Option + = on Mac to open a quick insert dialog. 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
New columns often inherit formatting from the column next to them, so 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 columns. 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 Ctrl + Alt + = on Windows or Cmd + Option + = on Mac. This opens a quick insert option without needing to right-click.
Will adding a column affect shared collaborators' view?
Yes, changes appear in real time for anyone with edit access. 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?
Yes. Tap and hold a column header to select it, tap the three-dot menu icon, then choose Insert 1 left or Insert 1 right. The process mirrors the desktop right-click menu but uses touch gestures instead.
Create interactive demos like this one — free, no coding required.
Start for free →