How to Add Columns in Google Sheets

Adding columns in Google Sheets can help you better organize and structure your data. It allows you to expand your spreadsheet, filter new information, and improve your data management skills. By the end of this tutorial, you will know how to perform each step needed to add columns in Google Sheets.

How to add columns in Google Sheets

Here is a quick guide on how to add columns:

1. Open your Google Sheet.

2. Highlight the column adjacent to where you want the new column.

3. Navigate to the Insert menu.

4. Hover over the Insert > Columns button.

5. Pick a direction to add your column.

6. Customize your column.

Now, let's go over each step in detail.

1. Open your Google Sheet.

To begin, open your Google Sheet or create a new one and enter your data.

2. Highlight the column adjacent to where you want a new column.

First, highlight the column that is directly to the right or left of the place you want to insert a new column. 

3. Navigate to the 'Insert' menu.

Then, click the Insert menu tab, and a list of options will appear.

4. Hover over the 'Columns' option. 

When you hover over the Columns option, you will see two options appear to the right of the Insert > Columns button. These options will read Insert 1 column left and Insert 1 column right. You will then choose which side of the highlighted column you’d want to add the new column to.

5. Customize your column width.

Once you've added the new column, you can customize the width of the column according to your data requirements. Adjust the width of the new column by hovering your cursor over the right-side boundary of the column header. When the cursor changes to a double-sided arrow, click and drag to resize the column width.

Common errors when adding columns in Google Sheets

When adding columns to Google Sheets, you may experience errors related to cell references or formulas. If you are using cell references for formulas in your Google Sheet, review and adjust your formulas' formatting to reflect new reference ranges or column numbers. A missing cell reference may lead to a “#REF!” warning, while a “#NAME?” means that the range you specified no longer exists or is misspelled.

How to insert multiple rows in Google Sheets

You may also want to add multiple rows or columns in Google Sheets at the same time. For columns, you follow the above steps but highlight several columns rather than just one. You will then have the option to insert the same number of columns as you highlighted. To insert multiple rows, follow these steps:

1. Open your Google Sheets document.

2. Select the row below where you want the new rows to appear.

3. If you need to insert more than one row, select as many rows as you need. For example, select seven existing rows if you need to insert seven rows.

4. Right-click on the highlighted rows.

5. In the drop-down menu that appears, click Insert rows above or Insert rows below as per your requirement. This will insert the same number of rows you selected in step three. For example, we highlighted seven rows in the instance shown below, so the menu options were updated to Insert 7 rows above or Insert 7 rows below.

Learn more with Coursera.

Interested in learning more skills with Google Sheets? Consider enrolling in the Google Data Analytics Professional Certificate to build analytical skills that can help you in a broad range of professions.