answersLogoWhite

0

Enter =sum(A1:A20) in the cell that you would like to display the sum, where A1:A20 is the range of cells you would like to add.

User Avatar

Wiki User

11y ago

What else can I help you with?

Related Questions

When and why are cells selected in Microsoft Excel?

Cells are selected constantly in using Excel. To enter anything into a cell it needs to be selected. To do things like format cells, they need to be selected. To do things like make charts, cells need to be selected. Cells are fundamental to using Excel, so anything you do with cells needs them to be selected.Cells are selected constantly in using Excel. To enter anything into a cell it needs to be selected. To do things like format cells, they need to be selected. To do things like make charts, cells need to be selected. Cells are fundamental to using Excel, so anything you do with cells needs them to be selected.Cells are selected constantly in using Excel. To enter anything into a cell it needs to be selected. To do things like format cells, they need to be selected. To do things like make charts, cells need to be selected. Cells are fundamental to using Excel, so anything you do with cells needs them to be selected.Cells are selected constantly in using Excel. To enter anything into a cell it needs to be selected. To do things like format cells, they need to be selected. To do things like make charts, cells need to be selected. Cells are fundamental to using Excel, so anything you do with cells needs them to be selected.Cells are selected constantly in using Excel. To enter anything into a cell it needs to be selected. To do things like format cells, they need to be selected. To do things like make charts, cells need to be selected. Cells are fundamental to using Excel, so anything you do with cells needs them to be selected.Cells are selected constantly in using Excel. To enter anything into a cell it needs to be selected. To do things like format cells, they need to be selected. To do things like make charts, cells need to be selected. Cells are fundamental to using Excel, so anything you do with cells needs them to be selected.Cells are selected constantly in using Excel. To enter anything into a cell it needs to be selected. To do things like format cells, they need to be selected. To do things like make charts, cells need to be selected. Cells are fundamental to using Excel, so anything you do with cells needs them to be selected.Cells are selected constantly in using Excel. To enter anything into a cell it needs to be selected. To do things like format cells, they need to be selected. To do things like make charts, cells need to be selected. Cells are fundamental to using Excel, so anything you do with cells needs them to be selected.Cells are selected constantly in using Excel. To enter anything into a cell it needs to be selected. To do things like format cells, they need to be selected. To do things like make charts, cells need to be selected. Cells are fundamental to using Excel, so anything you do with cells needs them to be selected.Cells are selected constantly in using Excel. To enter anything into a cell it needs to be selected. To do things like format cells, they need to be selected. To do things like make charts, cells need to be selected. Cells are fundamental to using Excel, so anything you do with cells needs them to be selected.Cells are selected constantly in using Excel. To enter anything into a cell it needs to be selected. To do things like format cells, they need to be selected. To do things like make charts, cells need to be selected. Cells are fundamental to using Excel, so anything you do with cells needs them to be selected.


How do you see which formulas is referring to a cell?

In Excel, you can see which formulas refer to a specific cell by using the "Trace Dependents" feature. Simply select the cell you're interested in, then go to the "Formulas" tab and click on "Trace Dependents." This will display arrows pointing to the cells that depend on the selected cell. Additionally, you can press Ctrl + [ to quickly navigate to the cells that reference the selected cell.


What is a selected group of cells in excel called?

range


In Excel When selected a column header how many cells are selected?

When you select a column header in Excel, all the cells in that column are selected. This means 65536 cells (the maximum number of rows in Excel). Similarly, if you select a row header, this will select 256 cells (the maximum number of columns in Excel). For more information on Excel Size and Cells: http://www.excel-hocam.com/mod/resource/view.php?id=18&username=guest


How do you name a selected range of cells in Excel 2007?

Select your cells. Go to the Formulas tab. Select the Name Manager. Then you can create a name for the selected cells.


What does a copy button do in excel?

It copies what is in the selected cell or cells at that time.


How do you print a graph paper in Excel or word?

In Excel, you can set the column width to 2 and display borders around the cells of the number of cells you would like to display on your graph paper, then print.


In Excel what is a highlight?

When you select cells, their colour changes to show that they have been selected, and that is often referred to as a highlight. So you could say that highlighted cells are selected cells.


What does the Clear All command in Excel do?

It clears the content and formatting of the selected cells.


Which Excel feature can be utilized to only allow the input of certain data such as dates times or numbers?

Validation is the feature that can limit what is entered into cells in Excel.


Suppose text entries in a row of a worksheet are running into each other you have already selected entries How can you choose to format the cells to fix the problem?

You can adjust the formatting of cells to prevent text from running into each other by clicking on the "Wrap Text" option in the "Alignment" group under the "Home" tab in Excel. This will automatically wrap long text entries within a cell and adjust the row height to display the entire text.


What is the Excel function that adds all the numbers in a selected range of cells is the?

Sum Function