Range - MS Excel

Range in MS excel is called the collection of two or more selected cell in a row or in a column.

In this section we will tell with with pictures the different stages of range and their uses as well as their working. 

Rows and Column

To select a cell click on that cell. in the following pic, selected one has selected a cell that is 

C3; C is column name and 3 means 3rd row. Each selection of a cell has its own name (ie C3)

Same like above, to select the whole of the column, simple click on C head as shown in the picture

To select the whole of the row, simple click on 3 head as shown in the picture below

To select a range of individual cells, hold down CTRL and click on each cell that you want to Select in the range.

 

Now the following are some example of some ranges

In the above pic, range is B2:C4 (Starting Letters are B and C means from B to C selection and then from 2 to 4 section)

All these operations of Range you can watch in the following Video