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"}

Google Sheets Magic Tricks!

Interactive, Easy and Free Way to Learn 5 Awesomely Cool Google Sheets Tricks!