0
You can use the plus sign or the sum function. So if you wanted to add the values in row 1 that are in cells A1, B1, C1, D1, E1, F1, G1, H1, I1, J1 and K1 you could do it like this:
=A1+B1+C1+D1+E1+F1+G1+H1+I1+J1+K1
or as a better way:
=sum(A1:K1)
Wiki User
∙ 14y ago
Wiki User
∙ 14y agoUse the SUM function.
EXAMPLE:
If you want to add the numbers in the cells from A1 to M1, you would put the following formula in cell N1: =SUM(A1:M1).
Wiki User
∙ 9y agoAssume you have a column of numbers ranging from A1 to A20. The formula I would use to total this column (I'm using Libreoffice Calc) would be placed in A21: =SUM(A1:A20). The same procedure to sum a row of cells is the same: =SUM(A1:Z1).
Wiki User
∙ 9y agoYou cannot re-number the actual rows. You could put your own numbers in cells in each row and use them for your purpose, but you cannot change the actual row numbers.
Wiki User
∙ 13y agoYou can highlight the range you want to add and click on the Auto-Sum button.
Wiki User
∙ 13y agoOne method is to highlight the numbers and click the SUM button.
Wiki User
∙ 14y agoright-click | insert | entire row
Wiki User
∙ 13y agoUse the insert a row above or below tab.
Add your answer:
Earn +20 pts
What is horizontal cells called in Excel?
A line of horizontal cells in Excel is known as a row.
How many intersection of row and column in ns Excel?
Each intersection of a row and column is a cell. So it will depend on which version of Excel you have There are 16,777,216 cells in Excel 2003 and earlier. There are 17,179,869,184 cells in Excel 2007 and after.
To add a row of cells quickly click on the located in the Function Library group?
Insert | Insert Sheet Rows
Why do they call a column a cell in Microsoft Excel?
A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.
What is the name of the cells arranged from left to right on Excel?
a row
What are boxes in Excel?
You may mean the cells in Excel. They are where a column and a row intersect. They are the main components of a spreadsheet.
What is the row height of Excel 2007?
By selecting an empty row and pressing Ctrl + 'Down arrow key', the selected cell will be the next item down the column. The row height in Excel 2010 is 1048576 cells.
In excel is a series of two or more adjacent cells in a column or row or a rectangular group of cells?
A group of cells is called a range.
What is the intersection of a column and row in Excel called?
The intersection of a column and row in excel called "cell"
What is the primary insert command and the row command on the insert menu?
Insert command which u get wen u right click in excel shift have options like u can add rows,columns,shift cells right and shift cells down but in row command on insert menu will allow u to insert one row.
What is auto sum?
Autosum allows you to quickly add values in ranges of cells. If you have a column of numbers and put the cursor on the cell below them and click the Autosum, it will automatically add the cells above it by highlighting the range into the formula. If you try the same thing at the end of a row, it will add those.
How do you insert a row with gaps or intervals one after the other within the contents in Microsoft Excel?
I do not understand what you are asking, but here is a possible response.If you want to insert multiple rows in an Excel workbook, click on the row number after which you would like to insert the blank rows. Then, click and hold to drag down the number of rows you want and insert blank rows.EXAMPLE: You want to add three blank rows between rows 5 and 6.Click on the number five (row header) to the left of row five.Hold down the mouse key and highlight rows 6 through 8 (that will highlight three rows).Go to the section in your version of Excel that inserts rows (in Excel 2007, that is the Home tab, Cells section, Insert -- click on insert cells).Observe that you have inserted three blank cells in your workbook. The old row 6 is now row 9.
