Selecting cells in an equation is a very important concept of a spreadsheet. We need to know how to reference the data in other parts of the spreadsheet. When entering your selection you may use the keyboard or the mouse.
We can select several cells together if we can specify a starting cell and a stopping cell. This will select ALL the cells within this specified BLOCK of cells.
If the cells that we want to work with are not together (non-contiguous cells) we can use the comma to separate the cells or by holding down the control-key (command key on a MAC) and selecting cells or blocks of cells the comma will be inserted automatically to separate these chunks of data.
For the following examples let's consider the table below:
This is just a discussion of selection methods. If we wanted to add the cells in the (To Select) you would type in
=sum(Type In)
or
=sum(Click On)
We can select several cells together if we can specify a starting cell and a stopping cell. This will select ALL the cells within this specified BLOCK of cells.
If the cells that we want to work with are not together (non-contiguous cells) we can use the comma to separate the cells or by holding down the control-key (command key on a MAC) and selecting cells or blocks of cells the comma will be inserted automatically to separate these chunks of data.
For the following examples let's consider the table below:
|
or
=sum(Click On)
| To Select | ||
| A1 |
| |
| A1, A2, A3 |
| |
| A1, B1 |
| |
| A1, B3 |
| |
| A1, A2, B1, B2 |
|