How to Add in Google Sheets: A Clear and Confident Guide

Published: December 12, 2023 - 3 min read

Hannah Recker
how-to-add-in-google-sheets

One of the most fundamental skills to master in Google Sheets is adding data to a sheet. Whether you are adding numbers, text, or formulas, there are several ways to add in Google Sheets. 

How to Add Two Cells in Google Sheets 

To add two cells in Google Sheets:

  1. Simply select the cell where you want the result to appear
  2. Enter the formula using the “+” operator.

 For example, to add the values in cells A1 and B1, you would enter “=A1+B1” in the cell where you want the result to appear.

You can also use the SUM function to add multiple cells. Simply enter “=SUM(A1)” in the cell where you want the result to appear to add the values in cells A1 through B1.

How to Add Multiple Columns in Google Sheets

To add multiple columns in Google sheets, multiple columns in Google Sheets:

  1. Select the column to the right of where you want the new column to appear. 
  2. Right-click the column header and select “Insert 1 right” from the dropdown menu. 

This will insert a new column to the right of the selected column.

How to Add Values to the New Column

To add values to the new column:

  1. Simply enter the values in the top cell 
  2. Use the fill handle to drag the formula down to the bottom of the column. The fill handle is a small blue square in the bottom right corner of the selected cell.
  3.  Click and drag the fill handle down to copy the formula to the cells below.

Combining Columns

You might want to merge first and last names or combine two columns of numerical data to perform calculations on the resulting values. Fortunately, Google Sheets offers several ways to achieve this.

Combining two columns in Google Sheets can be achieved using several techniques, including the CONCATENATE function, the ampersand symbol, the CONCAT function, and the TEXTJOIN function

4 Methods on how to Combine two columns in Google Sheets 

  1. The CONCATENATE function. This function allows you to join two or more text strings into a single cell. To use it:

Simply type “=CONCATENATE(A1,B1)” into a new cell, where A1 and B1 are the two cells you want to combine.

spreadsheet ai
Free AI-Powered Tools Right Within Your Spreadsheet

Supercharge your spreadsheets with GPT-powered AI tools for building formulas, charts, pivots, SQL and more. Simple prompts for automatic generation.

You can also use the “&” symbol instead of CONCATENATE, like so: “=A1&B1”.

  1. The ampersand symbol (&). This symbol is a shortcut for the CONCATENATE function and can be used in the same way. 

For example, if you want to combine columns A and B, you can: Type “=A1&B1” into a new cell.

  1. The CONCAT function. This function allows you to join two or more text strings and add a separator between them. To use it:

Simply type “=CONCAT(A1,” – “,B1)” into a new cell, where ” – ” is the separator you want to use.

  1. The TEXTJOIN function. This function allows you to join two or more text strings and add a delimiter between them. To use it:

Type “=TEXTJOIN(” – “,TRUE,A1)” into a new cell, where ” – ” is the delimiter you want to use and A1 are the two cells you want to combine.

In conclusion, adding cells and columns in Google Sheets is a simple process that can help you organize and analyze your data. By using formulas and functions, you can quickly and easily add value, combine columns,  and calculate totals.

Sync Live Data into Your Spreadsheet

Connect Google Sheets or Excel to your business systems, import your data, and set it on a refresh schedule.

Try the Spreadsheet Automation Tool Over 350,000 Professionals are Raving About

Tired of spending endless hours manually pushing and pulling data into Google Sheets? Say goodbye to repetitive tasks and hello to efficiency with Coefficient, the leading spreadsheet automation tool trusted by over 350,000 professionals worldwide.

Sync data from your CRM, database, ads platforms, and more into Google Sheets in just a few clicks. Set it on a refresh schedule. And, use AI to write formulas and SQL, or build charts and pivots.

Hannah Recker Growth Marketer
Hannah Recker was a data-driven growth marketer before partying in the data became a thing. In her 12 years experience, she's become fascinated with the way data enablement amongst teams can truly make or break a business. This fascination drove her to taking a deep dive into the data industry over the past 4 years in her work at StreamSets and Coefficient.
350,000+ happy users
Wait, there's more!
Connect any system to Google Sheets in just seconds.
Get Started Free

Trusted By Over 20,000 Companies