in EXEL- how do you add colums?

Question

adding meaning 2+2, not the colums themselves

Answer 1

Use =sum(a1:a10) where a is the column and 1 and 10 are the beginning and end cells. The formula can go anywhere except within the range.

Answer 2

In Excel you have 256 columns to work with, if this is not enough then you'll need to consolidate some of your data. If you just want to insert a column between other columns, use Insert, Columns from the top menu.

Answer 3

Inserting columns or adding as in getting the sum?

To add additional columns, click on the letter of the column (it will select the column) click insert and then column and it will add a column to the left of the selected column.

(Addition)
Click at the end of the column and click on the sum button (it is the greek symbol) It will highlight the fields it will sum (make changes if neccessary) and press enter.

Answer 4

If you need to add the columns together then type the formula..........If you need to Add the amounts in the cell A1 and A2 then type the formula....=A1+A2.....whenever you hit enter the answer will appear......same formula goes for multiplication...division.... and...subtraction....to show the formula in case a manager or someone needs to see it then press....tools....options... then put a check infront of Formulas

Answer 5

If typed into an empty cell
=SUM(A:A)
sums everything in column A.
=SUM(A:C)
sums everything in column A through C
=SUM( B1:D22)
Sums everything in the rectangle defined by the corners B1 and D22
you can also highlight the range to enter the cell range
=SUM("highlight your cells")
you can also sum multiple ranges
=SUM(A1:A10,B1:B5,C1:C6)

Answer 6

I am afraid you can't. Exel is limited on both columns and rows.

Columns reach IV (256) and rows 65536

Answer 7

in EXCEL from menu bar

insert
columns