How to Add Columns in Google Sheets

One cool feature of Google Sheets is the ability to insert and add new columns to your data tables. This is especially useful if you have a general format that you want to maintain throughout the table.

Addig Columns in Google Sheets

Step #1: Select Your "Parent" Column

Addig Columns in Google Sheets Step 1

First, you will click anywhere on a column that will be to the right or left of your new one. I personally like call it the "Parent" column, but that isn't some sort of official nomenclature. 

Step #2: Click "Insert"

Addig Columns in Google Sheets Step 2

Next, click "Insert", located in the header section. Then, the drop-down menu will show two options for inserting new columns; Column Left and Column Right. 


Column Left: Adds a new column to the left of the "Parent".

Column Right: Adds a new column to the right of the "Parent".


Note: As you can see, you also have the option to insert rows.

Step #3: Fill in Your New Column

Addig Columns in Google Sheets Sep 3

As you can see, there is a new, blank column that matches the design of the "Parent" column. However, you will need to make a few tweaks to make it an exact copy, such as the way that the border is formatted.

And there you have it; that is how you add new columns to your data tables.

Leave a Reply

Your email address will not be published. Required fields are marked

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}