Saturday, February 15, 2020

Fill range and move range in excel

Fill Range

At first input a value on the cell A2 then drag the right corner down into cell  A7.

Another example:
Enter the value  2 on cell A2  and  A3 cell 3 . After that select cell A2 and press shift then A3 and click the right corner also drag it down.
Date ways range 
This use for automatic range based pattern you infuse in two cells.Infuse the date 4/2/2015 into A2 and infuse date 5/2/205 into A3. After that select cell A2 and A3 and click the right corner and drag it down to A7
Move new location
You can move the value of range together by select the border of  the range and dragging into new location.
Insert a row between a range
To insert value between these range we have to follow some step.Press right and click insert.
After that you see this row shift down. This way you can insert column as much as you need.

Copy whole range and move
Select copy the range and paste where you want to paste.


No comments:

Post a Comment