Range in MS Excel






  • A range in Excel is collection of two or more cells
  • Or we can say it is group of cell that has been selected. 
Let's start with Overview of important range operations.
How to select a Cell, Row and Column.
Let's start 
1. To select Cell B2 
>> click on the box at the intersection of column B and row 2.
2. To select Row 2 
>> click on the row 2 header

3. To select column B
>> click on the column B header.

Range Examples


As we have told earlier, range is a collection of two or more cells.
Let's start with examples :
1. How to select the range A2:B4,
>> click on cell A2 and drag it to cell B4.
2. How To select a range of individual cells
>> hold down CTRL and click on each cell that you wants to be included in the range.

How to fill a Range


To fill a range, follow these simple steps.
First 
>> Enter the value 6 into cell C2.
>> Select cell C2, click on the lower right corner of cell C2 and drag it down to cell C6.
Result will be >>>>
Now, this dragging technique is very often used in the excel , so it is very important to learn it.
Lets revise by one more example >>> .
Second 
. >> Enter the value 3 into cell C1 and the value 6 into cell C2.

>>. Select cell C1 and cell C2, click on the lower right corner of this range and drag it down.
Excel will automatically fill the range based on the pattern of the first two values. 
Interesting….. What say….
Lets see another example ..
>>. Enter the date 2/8/2018 into cell C2 and the date 4/8/2018 into cell C3.
>>. Select cell C2 and cell C3, click on the lower right corner of this range and drag it down like we have done earlier.
Isn't the result amazing.…..try more, u will feel wonders...

How to Move a Range


To move a range, take following steps.
1. >> Select a range 
>> click on the border of range.

2. Drag the range to its new location. Like we have moved the range here from Column B to Column E . result is >>
you can do it for any column

How to Copy and Paste a Range


To copy and paste a range, take following steps.
1. >> Select the range
>> Right click
>> Click Copy (or press CTRL + c).**CTRL + c is shortcut key for copy

2. .>> Select the cell where you want the first cell of the range to appear
>> Right click
>> then click Paste under 'Paste Options:' (or press CTRL + v).**CTRL + v is shortcut key for paste

How to Insert Row


>> how to insert a row between the values 2016 and 2018
>> Select row 4
>> right click
>> click Insert and u will get the result as 

How to Insert column 


>> how to insert a column between the values 2016 and 2018
>> Select column c

>> right click
>> click Insert and u will get the result as 

Must read for you :