To add columns in Google Sheets, right-click the column header letter next to where you want the new column and choose “Insert 1 column left” or “Insert 1 column right.” That’s the quickest way to insert a single column, and the same right-click menu lets you add multiple columns at once by selecting several column headers first.
How to add columns in Google Sheets: the right-click method
Right-clicking a column header is the most intuitive method for most users because it places the insert option exactly where you’re already working. Start by opening your spreadsheet in Google Sheets on your computer. Then click the letter at the top of the column that sits next to where you want the new column to appear, for example, click column B if you want to insert a column between A and B.
- Select the column header (the letter) of the column next to where you want to insert.
- Right-click the selected column header.
- From the menu that appears, choose “Insert 1 column left” or “Insert 1 column right.”
The new column appears instantly, and all existing columns shift to accommodate it. Your formulas and data remain intact, so you can start typing in the new column right away.
How to insert multiple columns at once
When you need to add several columns at the same time, you don’t have to repeat the single-column process over and over. Instead, highlight the same number of columns you want to insert, Google Sheets will add exactly that many new columns in one step. This is especially useful when you’re building out a dataset or restructuring a large spreadsheet.
- Highlight the number of columns you want to add by clicking and dragging across the column headers, or use Ctrl + click (Windows) or ⌘ + click (Mac) to select multiple non-adjacent columns.
- Right-click any of the selected column headers.
- From the menu, select “Insert [Number] columns left” or “Insert [Number] columns right.”
For example, if you highlight columns C, D, and E and choose “Insert 3 columns left,” three new columns appear to the left of C, and your original columns shift right. This method preserves the exact number of columns you selected, so you can plan your layout precisely.
Keyboard shortcuts to add columns faster
If you prefer keeping your hands on the keyboard, Google Sheets offers shortcuts that combine column selection and insertion. First, select the column where you want the new one to appear using Ctrl + Space on Windows or ⌘ + Space on Mac. Then press Ctrl + Alt + = on Windows or ⌘ + Option + = on Mac to insert a new column to the left of the selected one.
To insert multiple columns with shortcuts, select the same number of columns you want to add, for instance, highlight three columns to add three new ones, then use the same shortcut combination. The new columns will appear to the left of your selection, and the existing columns shift right. This method is ideal for repetitive tasks where you want to avoid reaching for the mouse, and it works identically whether you’re adding one column or several.
How to add columns on the Google Sheets mobile app
On Android and iOS, the process is slightly different but still straightforward. Open a spreadsheet in the Google Sheets app on your phone or tablet, then tap the column header letter to select the column next to where you want the insert. A menu bar appears at the bottom of the screen with options like Insert, Delete, and more. Tap the plus icon or the “Insert” option, then choose whether to add a column to the left or right of your selection.
For multiple columns on mobile, select the same number of columns you want to add by tapping and dragging across the headers, then repeat the insert step. The mobile interface is optimized for touch, so the menu options are large and easy to tap, even on smaller screens. While the right-click and keyboard methods are faster on a computer, the mobile app gives you full editing capability when you’re away from your desk.
Google Sheets column limits and undo tips
Before you add many columns, it’s worth knowing the boundaries of a single spreadsheet. Google Sheets caps the total number of columns at 18,278, which corresponds to column ZZZ. Additionally, the entire workbook, across all tabs, can hold a maximum of 10 million cells. So if you’re working with a large dataset, keep those limits in mind when planning how many columns to insert.
If you make a mistake or change your mind after inserting a column, you can undo the action instantly with Ctrl + Z on Windows or Cmd + Z on Mac. This works for any column insertion, whether you used the right-click menu, keyboard shortcuts, or the mobile app. You can press it repeatedly to undo multiple inserts, which gives you the freedom to experiment with column placement without worrying about permanent errors.
