How To Quickly Add Columns In Google Sheets

Google Sheets is an incredibly handy tool that lets you create, manipulate, and manage spreadsheets all within your browser. Whether you’re tracking budget expenses or organizing a project, Google Sheets has got you covered. Today, we’ll walk you through the simple steps of how to quickly add columns to your Google Sheets.

Step 1: Open your Google Sheet

To start, open your Google Sheets document. This can be done by going to Google Drive, then clicking on the spreadsheet you wish to edit.

Step 2: Select the Column Header

Next, click on the header of the column after which you want to add a new column. Column headers are the letters you see at the top of the spreadsheet (A, B, C, and so on).

Step 3: Right Click

Now, right click on the selected column header. A menu will appear.

Step 4: Add a Column

In the menu that appears, click on ‘Insert 1 left’ or ‘Insert 1 right’ depending on where you want your new column to be placed.

Adding Multiple Columns

If you need to add multiple columns at once, the process is just as simple. Here’s how:

Step 1: Select Multiple Column Headers

Click on the first column header you want to select, then hold down the Shift key on your keyboard. While holding the Shift key, click on the last column header you want to select. This should select all the columns in between.

Step 2: Right Click

Like before, right click on one of the selected column headers. This will bring up the same menu as before.

Step 3: Add Columns

Click on the ‘Insert X left’ or ‘Insert X right’ option (where X is the number of columns you initially selected). This will add that many new columns in the position you’ve chosen.


Adding columns in Google Sheets is an easy and intuitive process. Whether you’re adding one column or several, the steps remain straightforward and quick. Remember, practice makes perfect, so don’t be afraid to experiment with these tools to make your spreadsheets work for you!