WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android


Add formula in Excel for entire column

August 1, 2022

If you want to use Excel to calculate numerical information, you will learn how excel add formula in this program to subtract, add, divide and multiply values in your workbook. You will also know several ways, where you can use the cell reference so that you can easily work the formulas.

It is important that you understand Excel functions so that you know how to excel add formula quickly and fast. So, the simplest way how to excel add formula will be explained in several methods below.

How to create an easy formula in Excel?

You can easily discover how excel add formula 2016 in simple steps so that you become a professional using this type of tool.

1.First select the cell where the answer appears (B4, as an example).

2. Type the equal (equal) sign, then type the formula you need Excel to calculate.

3. Then press Enter to calculate the formula, the value is displayed in the cell.

How to create the formulas with cell references?

This method is quite useful and fast so that you can update the data in your spreadsheet without having to type all the values in the formula. You can also know how to excel add formula 2019 whenever you want.

1.Choose the cell where the answer can appear, an example would be (B3)

2.Then write the equals sign (=) and write the address of the first number in the equation.

3. Now type the operator you want for your formula, such as putting the plus sign (+). Then write the address of the cell that has the second number of the equation (B2)

4. Press Enter for the value to be calculated and the formula to be displayed in the cell. This will help you use without problem excel add formula

How to create a formula using the point and click method?

It is important that you know everything about excel add formula easily in several steps. In this way you can advise your friends to learn about excel add formula online.

1.You must choose the cell where the answer appears.

2. Type the equals sign(=), click where the first cell you will place in the formula is located.

3. Then write the operator you require for the formula, you can use the multiplication sign * as an example. Click on the next cell in the formula (Be as an example).

4. Press where it is Enter and calculate the value and the formula that will be displayed in the cell.

If you have easily understood the above methods of excel add formula. In this way, you will feel like an expert using Excel, you can also discover what it offers you as excel add formula mac.

If you have felt like learning more about excel add formula, it will be essential that you enter the WPS Academy platform. So don't stop going to this platform so you can download WPS Office easily and at no cost.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.