Spreadsheets- Advanced Calculations

Selecting Rows and Columns

1. Click on the desired row number or the column letter.

   

2. The entire row or column will be selected and highlighted in blue.
3. Any changes made will apply to the entire row or column.

Selecting Multiple Rows and Columns

1. Click on the desired row number or column letter.
2. Holding down the Control key, select other rows and/or columns.
3. All rows and/or columns selected will be highlighted in blue.
4. Any changes made will apply to all the rows and/or columns selected.

   

Selecting Ranges

Ranges are merely a group of cells that lay adjacent to each other. Ranges can be select along vertically adjacent cells, horizontally adjacent cells, or both. Ranges of cells are useful when using functions in Excel.

1. Click on the first cell in your range. Our first cell is B3.
2. Holding down the Control key, select the adjacent cell you want to include in that range.
3. The selected cells will be highlighted in blue.
4. We have select a range of twelve cells named B3:D6 because those are the cells in which the range begins and ends.

   

Selecting Multiple Cell Ranges

1. Follow the same procedure for Selecting Ranges.
2. Holding the Control key, repeat those procedures for the next range you want to select.
3. Both ranges will be highlighted in blue.

   

   |    Next