How To Add More Columns In Google Sheets

Today, we are going to learn a simple yet handy skill that can significantly improve your experience in using Google Sheets. Whether you are a business professional, student, or just someone who loves to organize things digitally, knowing how to add more columns in Google Sheets is essential.

Why Adding More Columns?

Adding more columns to your spreadsheet is not only about expanding the workspace. It is also about enhancing the layout of your data, organizing information better, and making data analysis more efficient. So, let’s dive into the process.

Steps to Add More Columns in Google Sheets

1. Open Your Google Sheets Document

The first step is to open the Google Sheets document you wish to add more columns to. Simply go to Google Drive, locate your document, and double-click on it to open.

2. Select the Column Header

Once your document is open, click on the letter at the top of the column next to where you want your new column to appear. For example, if you want to insert a column between A and B, you would click on the column header labeled ‘B’.

3. Right-Click and Select ‘Insert 1 Left’ or ‘Insert 1 Right’

After selecting the column header, right-click on it. A dropdown menu will appear. You can then choose either ‘Insert 1 left’ or ‘Insert 1 right’, depending on where you want the new column to be placed. If you select ‘Insert 1 left’, the new column will be inserted to the left of the selected column, and if you choose ‘Insert 1 right’, it will be placed to the right.

4. Repeat The Process

If you need to add more than one column, simply repeat this process as many times as necessary.

Adding Multiple Columns at Once

If you need to add multiple columns at once, Google Sheets allows you to do this in a single step. Here’s how:

1. Select the Number of Columns You Need

To do this, click on a column header, then, while holding down the shift key, click on the number of additional column headers that matches the number of columns you want to add. For example, if you want to add three new columns, you should select three column headers.

2. Right-Click and Choose ‘Insert columns’

After selecting the number of columns, right-click on the selected columns and choose ‘Insert columns’ from the dropdown menu. The same number of new columns as you initially selected will then be inserted to the left of your selection.


Adding more columns in Google Sheets is a straightforward process. Hopefully, this guide has made it even simpler for you. Happy organizing!