How to Add a Column in Google Sheets: A Step-by-Step Guide

Adding a column in Google Sheets is a breeze once you know the ropes. All you need to do is right-click on the column header where you want the new column to appear, and then select either “Insert 1 left” or “Insert 1 right” from the dropdown menu. It’s that simple! Now, let’s dive deeper into the step-by-step process so you can become a Google Sheets pro.

Step by Step Tutorial: How to Add a Column in Google Sheets

Before we jump into the steps, it’s important to note that adding a column in Google Sheets will help you organize your data better. Whether you need to include more information or just want to keep your spreadsheet tidy, adding a column is the way to go.

Step 1: Select the Column

Click on the column header next to where you want the new column to appear.

Selecting the correct column is crucial because the new column will be added either to the left or right of the selected column. Make sure you click on the letter at the top of the column to select it properly.

Step 2: Right-Click to Open the Menu

Right-click on the selected column header to open the dropdown menu.

After right-clicking, a menu will appear with several options. It’s important to click cautiously to avoid selecting the wrong option.

Step 3: Choose ‘Insert 1 Left’ or ‘Insert 1 Right’

From the dropdown menu, choose ‘Insert 1 left’ to add a column to the left or ‘Insert 1 right’ to add a column to the right.

Depending on where you want your new column to be placed, you can choose either ‘Insert 1 left’ or ‘Insert 1 right’. This action will instantly add a new column in the desired location.

After completing these steps, a new column will be added to your Google Sheets document. You can then start inputting data into the new column or adjust the width and formatting as needed.

Tips for How to Add a Column in Google Sheets

  • Double-check the location where you want the new column to ensure it’s added in the right spot.
  • Use the keyboard shortcut ‘Ctrl’ + ‘+’ (Cmd + ‘+’ on Mac) to quickly add a new column.
  • If you want to add multiple columns at once, select the number of existing columns equal to the number you want to add, then right-click and choose to insert columns.
  • Remember to adjust the width of your new column if it’s too narrow or wide for your data.
  • Undo any mistakes by pressing ‘Ctrl’ + ‘Z’ (Cmd + ‘Z’ on Mac) to revert your spreadsheet to the previous state.

Frequently Asked Questions

Can I add a column on the Google Sheets mobile app?

Yes, you can add a column in the Google Sheets mobile app by tapping the column header and selecting the “Insert column” option.

Is there a limit to how many columns I can add?

Google Sheets currently allows a maximum of 18,278 columns per sheet, so you can add plenty of columns before hitting that limit.

What happens to my data when I add a new column?

Your existing data will shift right if you add a column to the left and left if you add a column to the right, making space for the new column.

Can I add a column to multiple sheets at once?

No, you need to add a column to each sheet individually, as there’s no feature to add columns to multiple sheets simultaneously.

How do I delete a column in Google Sheets?

To delete a column, right-click on the column header and select “Delete column” from the dropdown menu.


  1. Select the column where you want to add a new column.
  2. Right-click to open the menu.
  3. Choose ‘Insert 1 left’ or ‘Insert 1 right’.


Mastering the simple task of adding a column in Google Sheets can significantly enhance your spreadsheet management skills. Once you’ve learned how to add a column, you can better organize your data, which is essential for analytics, reporting, or just keeping track of information. Remember, practice makes perfect, so don’t hesitate to try out this feature next time you’re working on a Google Sheets document. And if you ever find yourself in a pickle, just refer back to this handy guide for a quick refresher. Happy sheeting!

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time. Read our Privacy Policy