Easy Steps to Add Columns in Google Sheets (2023)

Jason Gong
June 6, 2024

Select a column, right-click, and choose Insert 1 left.

By the way, we're Bardeen, we build a free AI Agent for doing repetitive tasks.

If you use Google Sheets, try Bardeen's GPT in Spreadsheets. It automates tasks like data analysis and formatting, saving you time.

Adding columns in Google Sheets is a crucial skill for organizing and expanding your spreadsheets effectively. Whether you need to insert a single column or multiple columns at once, understanding the process can help you manage your data more efficiently. In this guide, we'll walk you through the step-by-step instructions for inserting columns in Google Sheets, as well as some advanced tips for working with newly added columns.

Introduction to Inserting Columns

Inserting columns in Google Sheets is a fundamental skill that allows you to organize and expand your spreadsheets effectively. Whether you're working with a small dataset or a complex project, knowing how to add columns in Google Sheets is essential for managing your information and making it easier to read and analyze.

There are various scenarios where you might need to insert columns in Google Sheets, such as:

  • Adding new categories or variables to your dataset
  • Separating data into smaller, more manageable sections
  • Creating space for calculations or formulas
  • Improving the overall layout and readability of your spreadsheet

In the following sections, we'll guide you through the process of inserting single and multiple columns in Google Sheets, as well as provide tips on resizing and adjusting columns to suit your needs. For more advanced features, consider adding GPT to Google Sheets to enhance your workflow.

How to Add a Single Column in Google Sheets

Adding a single column in Google Sheets is a simple process that can be done in just a few steps:

  1. Open your Google Sheets spreadsheet.
  2. Select the column to the right of where you want to insert the new column by clicking on the column header (e.g., column B if you want to insert a new column between A and B).
  3. Right-click on the selected column header.
  4. From the context menu that appears, choose "Insert 1 left."

Alternatively, you can use keyboard shortcuts to insert a single column:

  • For Windows/Chrome OS: Alt + I, then C
  • For Mac: Control + Option + I, then C

Using these shortcuts will insert a new column to the left of the currently selected column, saving you time and increasing your efficiency when working with Google Sheets. For more advanced tasks, you can connect Excel with Google Sheets to streamline your workflow.

Connect Google Docs to automate tasks and save time when updating and managing your documents.

Adding Multiple Columns at Once

To insert multiple columns simultaneously in Google Sheets, follow these steps:

  1. Select the column header to the right of where you want to insert the new columns.
  2. While holding the Shift key, click on the column header corresponding to the number of columns you want to add. For example, if you want to insert three new columns, click on the header three columns to the right of your initial selection.
  3. Right-click on any of the selected column headers and choose "Insert [number] columns left" from the context menu.

Alternatively, you can use the following keyboard shortcuts to add multiple columns:

  • Windows/Chrome OS: Alt + I, then C
  • Mac: Control + Option + I, then C

After inserting the new columns, you can use the fill handle (the small square in the bottom-right corner of a cell) to quickly duplicate the formatting and contents of existing columns into the new ones. Simply click and drag the fill handle across the new columns to apply the desired formatting and formulas. For more advanced features, consider using web scraper extensions to enhance your Google Sheets experience.

Resizing and Adjusting Columns After Insertion

After inserting new columns in Google Sheets, you may need to resize them to fit your data or to maintain a consistent look throughout your spreadsheet. Here's how to resize columns:

  1. Hover your mouse over the right border of the column header you want to resize until the cursor changes to a double-headed arrow.
  2. Click and drag the column border to the left or right to adjust the width of the column. Release the mouse button when the column reaches the desired size.

To resize a column to fit its contents automatically, double-click on the right border of the column header. This will adjust the width to accommodate the longest entry in that column.

You can also resize multiple columns at once:

  1. Select the column headers of the columns you want to resize by clicking and dragging your mouse across them or by holding the Shift key and clicking on the first and last column headers in the range.
  2. Right-click on any of the selected column headers and choose "Resize columns" from the context menu.
  3. Enter the desired width in pixels or choose "Fit to data" to automatically adjust the selected columns to fit their contents.

By resizing and adjusting your columns after insertion, you can ensure that your Google Sheets spreadsheet remains organized and easy to read. For more advanced features, consider learning how to enrich LinkedIn profiles in Google Sheets.

Bardeen can save you time by using its Google Drive integration. Automatically manage your files and keep everything organized without opening Google Drive.

Advanced Tips: Using Formulas and Functions with New Columns

When working with newly inserted columns in Google Sheets, you can leverage formulas and functions to perform data analysis and manage your information effectively. Here are some examples and tips:

  1. Use the SUM function to calculate the total of values in a new column. For example, if you have a new column with numeric data in cells A1 to A10, you can use the formula =SUM(A1:A10) to calculate the sum of those values.
  2. Apply the AVERAGE function to determine the mean value of data in a new column. If you have a new column with numeric data in cells B1 to B20, you can use the formula =AVERAGE(B1:B20) to find the average of those values.
  3. Utilize the ARRAYFORMULA function to apply a formula to an entire column. This is particularly useful when working with new columns. For example, if you want to multiply the values in column A by 2 and display the results in a new column B, you can use the formula =ARRAYFORMULA(A1:A*2) in cell B1.

In addition to these basic functions, Google Sheets offers advanced features like Array Formulas and the QUERY function, which can help you manage data in new columns more efficiently:

  • Array Formulas allow you to perform complex calculations on multiple values or ranges simultaneously. By combining Array Formulas with functions like VLOOKUP, INDEX, or MATCH, you can search for and retrieve data from other columns or sheets based on specific criteria.
  • The QUERY function enables you to run SQL-like queries on your Google Sheets data, which can be particularly useful when working with large datasets spanning multiple columns. You can use the QUERY function to filter, sort, and aggregate data in your newly inserted columns based on specific conditions.

By leveraging these formulas and functions, you can transform your newly inserted columns into powerful tools for data analysis and management, saving time and increasing productivity in your Google Sheets workflows.

Automate Your Google Sheets with Bardeen Playbooks

While adding columns in Google Sheets can be done manually, automating this process and other related tasks can significantly enhance productivity and data management. Bardeen offers powerful automation playbooks for Google Sheets that streamline various tasks, from syncing data across platforms to creating tasks based on spreadsheet modifications.

Here are some examples of how Bardeen can automate your Google Sheets workflows:

  1. Create a ClickUp task when a Google Sheets spreadsheet is modified: This playbook automatically creates a task in ClickUp whenever a Google Sheets spreadsheet is updated, perfect for project managers needing to track changes in real time.
  2. Create Coda entry when a row is added in Google Sheets: Seamlessly add entries to Coda tables from new rows in Google Sheets, ensuring data consistency across your tools.
  3. Copy an Airtable to Google Sheets: Easily transfer data from Airtable to Google Sheets with a single click, enabling efficient data management and analysis.
Automate Google Sheets with Bardeen's GPT

Use Bardeen's GPT in Spreadsheets to automate and enhance your Google Sheets tasks.

Get Bardeen free

Other answers for Google Sheets

Auto Color Code Cells in Google Sheets Guide 2024

Learn to automatically color code cells in Google Sheets using conditional formatting for better data visualization and analysis.

Read more
Disable Google Sheets Downloads: A Step-by-Step Guide

Learn how to disable downloads in Google Sheets by adjusting share permissions and protecting sheets, enhancing data security.

Read more
Download Parts of Google Sheets Easily in 5 Steps

Learn how to download specific parts of Google Sheets using the sheet's GID for efficient data sharing and analysis. Streamline your workflow today.

Read more
Download Images & Charts from Google Sheets: A Guide

Learn how to download images and charts from Google Sheets directly or from a URL list to Google Drive, including step-by-step instructions.

Read more
Download Excel from Google Sheets in Simple Steps

Learn to download Excel from Google Sheets in a few steps, ensuring file compatibility and offline access. Perfect for Excel users.

Read more
Convert Date to Month Name in Google Sheets: 4 Easy Steps

Learn how to convert numeric dates to written months in Google Sheets using TEXT function, custom formatting, and more for enhanced data presentation.

Read more
how does bardeen work?

Your proactive teammate — doing the busywork to save you time

Integrate your apps and websites

Use data and events in one app to automate another. Bardeen supports an increasing library of powerful integrations.

Perform tasks & actions

Bardeen completes tasks in apps and websites you use for work, so you don't have to - filling forms, sending messages, or even crafting detailed reports.

Combine it all to create workflows

Workflows are a series of actions triggered by you or a change in a connected app. They automate repetitive tasks you normally perform manually - saving you time.

get bardeen

Don't just connect your apps, automate them.

200,000+ users and counting use Bardeen to eliminate repetitive tasks

Effortless setup
AI powered workflows
Free to use
Reading time
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
By clicking “Accept”, you agree to the storing of cookies. View our Privacy Policy for more information.