0
The best way is to use the SUM function. If the block of cells you wanted to add were all the cells from A2 to C10, then you would type this:
=SUM(A2:C10)
Wiki User
∙ 9y ago
Add your answer:
Earn +20 pts
How many cells in a 2007 Excel sheet?
17,179,869,184 cells in one excel
Why are excel absolute ranges called ranges?
A range is a group or block of selection of cells. The term range can in ordinary language mean a group of things, or something going from one point to another, which a block of cells does. It is a group of cells and it has a starting and ending point, which would be the top-left and bottom-right cells.
What are the two kinds of columns in Excel?
Excel has only one type of column -- a vertical stack of cells.
How do you change multiple hyperlinks in Excel worksheet?
Hyperlinks can only be changed one at a time. You can select a range of cells and apply the same link to all of them, even without text in them. Select the cell or cells and press Ctrl - K to open the dialog box. You cannot put different links into the cells at one time. So if your cells are to have different links, then they have to be done one at a time. If one block of cells have all set to have the same link, then that can be removed at once. If there are different links in a block of cells, then each link must be removed individually.
What kind of formula is function in Excel?
A function is a pre-written or built-in formula in Excel. There are many of them, all designed to do very specific tasks. The SUM function is one of the most common, making it easy to add a range of cells. See the related question below.
What is the symbol that you use when you want to add up a set of numbers together on a spreadsheet?
If you mean Excel, you can add numbers one at a time with the "+" symbol. To add a larger range of cells, you need to use the sum() function. Don't forget that Excel formulae start with the "=" symbol. Example: = sum(a1:b10) As a convenient shortcut, once you type "sum(", you can select the range with the mouse.
What is a contiguous range in Excel?
There is no such thing as a non-contiguous range. A range is a group of cells that are together in a rectangular block. Non-contiguous refers to cells that are not touching. So you can have more than one range which do not touch, so what you have are non-contiguous ranges. It is possible to select non-contiguous ranges by first selecting one range and then while holding the Ctrl key, select other ranges.
How do you get excel to ignore blank cells in a chart or how can you select only specific cells to put into the chart?
Excel is too alert and observant to ignore anything. The second method is therefore the correct one.
What combines a range of cells into one cell that occupies the same amount of space in an excel worksheet?
The Merge Cells option.
What command combines a range of cells into one cell that occupies the same amount of space in excel?
The name is "merge and center", which combines all highlighted cells. For newer versions of Excel this is on the "Home" tab.
How do you take and Excel 2003 cell and break it into multiple cells?
A cell is the smallest unit in Excel, you cannot break it into multiple cells. However, if you have merged multiple cells into one large cell, you can break that merged cell into multiple cells by unmerging the single large merged cell.
How do you block your friends on myspace so that no one will add them?
You can't block someone so that no one ELSE will add them. You can only block them from contacting you. Add me ;D http://www.myspace.com/hyperharley That is not so..... you can add the code.... this will hide your friends list... hope this helps keep your secret. Otherwise you can go to edit friends and block individuals and set your profile to private.
