How to Add 2 Columns in Excel: Every Method Explained

Adding two columns in Excel sounds straightforward — and often it is. But depending on what you actually mean by "add," the right approach can vary quite a bit. Are you combining the values in two columns mathematically? Joining text from two columns into one? Or physically inserting new columns into your spreadsheet? Each scenario uses a different tool, and picking the wrong one wastes time or breaks your data.

Here's a clear breakdown of every method that matters.

What "Adding" Two Columns Can Mean

Excel users typically mean one of three things:

• Summing numbers — adding the numeric values in two columns together (e.g., Column A + Column B = total)
• Concatenating text — merging text from two columns into a single cell (e.g., First Name + Last Name)
• Inserting columns — adding blank columns into the spreadsheet structure itself

Each has its own approach. Getting clear on which one you need is the first step.

Method 1: Add the Values of Two Columns (Math) ➕

This is the most common use case — you want to calculate the sum of values across two columns, row by row or as a grand total.

Row-by-Row Addition

If Column A contains sales figures and Column B contains returns, and you want a net figure in Column C:

1. Click on cell C1 (or wherever you want the result)
2. Type: =A1+B1
3. Press Enter
4. Click back on C1, then drag the fill handle (the small square at the bottom-right of the cell) down to apply the formula to every row

This creates a formula-based column that updates automatically when A or B changes.

Using SUM Across Two Columns

If you want a single total that adds up an entire column A and an entire column B together:

=SUM(A:A, B:B) 

Or for specific ranges:

=SUM(A1:A100, B1:B100) 

This is useful for dashboards or summary rows where you need one number representing both columns combined.

Using AutoSum

For quick addition without typing formulas:

1. Click an empty cell below or beside your data
2. Go to Home → AutoSum (or press Alt + =)
3. Excel will suggest a range — adjust it if needed to include both columns
4. Press Enter

AutoSum works well for simple adjacent ranges but requires manual adjustment when your two columns aren't side by side.

Method 2: Combine Text from Two Columns (Concatenation) 🔤

If you're working with names, addresses, product codes, or any text-based data, you may want to merge two columns into one readable string.

Using the Ampersand Operator

The simplest approach:

=A1&" "&B1 

This joins the text in A1 and B1 with a space in between. You can replace " " with a comma, dash, or any separator you need.

Using the CONCAT or CONCATENATE Function

=CONCAT(A1, " ", B1) 

CONCAT is available in Excel 2016 and later. The older CONCATENATE function works the same way and is still supported for backward compatibility.

Using TEXTJOIN (More Flexible)

=TEXTJOIN(" ", TRUE, A1, B1) 

TEXTJOIN lets you specify a delimiter (the character between values) and whether to ignore blank cells. It's particularly useful when you're joining more than two columns or when some cells may be empty.

Method 3: Insert New Columns Into Your Spreadsheet

Sometimes "adding columns" means physically placing blank columns into your spreadsheet — not performing calculations.

Insert a Single Column

1. Click the column letter at the top (e.g., click "C" to select the whole column)
2. Right-click and select Insert
3. A blank column appears to the left of where you clicked

Insert Multiple Columns at Once

1. Click and drag across two column letters at the top to select two adjacent columns
2. Right-click and choose Insert
3. Excel inserts the same number of blank columns as you selected

This method is non-destructive to your data — existing columns shift right to make room.

Key Differences Between Methods

Factors That Affect Which Method Works for You

A few variables determine which approach fits your situation:

Your Excel version matters. TEXTJOIN and CONCAT aren't available in Excel 2013 or earlier. If you're on an older version, you'll need to use CONCATENATE or the ampersand method instead.

Your data type is critical. Applying a math formula (=A1+B1) to cells containing text returns a #VALUE! error. Excel treats numbers stored as text differently from true numeric values — a common source of confusion when data is imported from external systems.

Whether you want live or static results changes the approach. Formula-based columns update automatically when source data changes. If you need a permanent, unchanging result, you'd paste the output as values only (Paste Special → Values) after running the formula.

Spreadsheet structure — whether you're using a formatted Excel Table versus a plain range — affects how formulas fill down and reference data. Excel Tables auto-expand formulas to new rows; plain ranges don't.

Common Issues and What Causes Them

• #VALUE! error — Usually means one column contains text where a number is expected. Check cell formatting.
• Formula not filling down — The fill handle may be disabled, or you're in a protected sheet.
• Merged cells causing problems — Merged cells can interfere with column insertion and formula ranges. Unmerge before working with large column operations.
• Results not updating — If your workbook is set to manual calculation (Formulas → Calculation Options), formulas won't recalculate automatically. Switch to Automatic.

The right method is rarely about complexity — it's about understanding what your data actually is and what output you need. Whether you're summing sales figures, assembling full names from split fields, or just reorganizing a spreadsheet layout, each scenario calls for a different tool. How those tools behave in practice depends on your data, your Excel version, and how your spreadsheet is structured.