By Shivani Garg
- 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 ..
>>. 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
Related >>
Labels:
MS Excel
Shivani Garg