How to add a whole column in Excel

February 22, 2022

When just starting out people often find themselves wondering how to add a whole column in Excel. Usually, a formula only applies to a range of cells, not the entire column.

This is actually really simple to achieve and I will show you two quick methods on how to do it: one with a formula, the other using Excel's Status bar.

How to add an entire column in Excel using a formula

  1. Select the cell where you want to insert the sum
  2. Type =SUM(
  3. Select the entire column by clicking on the column letter
  4. Type ) to finish the formula and hit Enter

In the example shown, the formula in D2 is =SUM(B:B). This sums up all values from column B.

How to add a whole column in Excel

If you need additional info, I also wrote an article on how to use SUM function in Excel.

How to add a column of numbers in Excel using the Status bar

The second option is to use the Status bar. This is useful when you just want a quick glance at the total sum of values, rather than actually calculating the sum using a formula.

  1. Select the entire column by clicking on the column letter
  2. Check the Sum field from the Status bar
How to add an entire column in Excel

Note: Be careful when referencing an entire column. While it may be useful to include all values in your formulas, this approach is prone to errors. If you accidentally insert a value anywhere in that column, it will be added to your result.

I hope this article showed you exactly how to add a whole column in Excel. However, in case you still have questions, don't hesitate to reach out.

About me
Radu from ExcelExplained

My name is Radu Meghes, and I'm the owner of excelexplained.com. Over the past 15+ years, I have been using Microsoft Excel in my day-to-day job. I’ve worked as an investment and business analyst, and Excel has always been my most powerful weapon. Its flexibility and complexity make it a highly demanded skill for finance employees. I launched excelexplained.com back in 2017, and it has become a trusted source for Excel tutorials for hundreds of thousands of people each year.

If you'd like to get in touch, you can contact me on LinkedIn.

Thousands of people have benefited from my free Excel lessons. My only question is, will you be next?

Essential Functions

Popular Articles

Excel courses

I have compiled a list of the best Excel online courses. It covers basic and advanced topics, VBA, and Power BI.
View courses
Excel is a very complex application, and understanding it on your own may prove difficult and time-consuming. I have created ExcelExplained.com to help you better understand each function and provide useful examples for different tasks. If you can’t find the answer to your question in one of the published articles, please leave a comment or send me an email, and I will do my best to help you out.

Affiliate Disclosure: When you purchase a product through a link on our website, I may earn an affiliate commission. There are no additional costs to you.
Copyright © 2017-2022 ExcelExplained.com
>