ADVANCE FILLING AND AUTO FILLING

Learn ADVANCE FILLING AND AUTO FILLING in Hindi, so that you can do your work very quickly and easily. After learning this, you can increase SPEED to work in your EXCEL.

Here we will learn how we can fill a DATA by DRAG  a CELL.

1. FILL SAME DATA.

2. FILLING SERIES OF NUMBER.

3. FILL the names of months and days.

4. CUSTOM LIST means making a list of your own.

5. FILL AUTO.

1 - FILL SAME DATA

So first we will see how we can fill any NUMBER or any DATA by DRAG (dragging).

STEP -1 #  First of all, we will type TYPE whatever FILL the DATA. Then SELECT it and move your mouse’s CURSOR down to CELL’s RIGHT SIDE, and our CURSOR, like the PLUS (+) sign, PRESS MOUSE’s LEFT BUTTON, as far as we need DATA We will pull him there and leave, then we get our DATA.

Here we will FILL NUMBER 1 for EXAMPLE.

ADVANCE FILLING AND AUTO FILLING
ADVANCE FILLING AND AUTO FILLING
2 - FILL NUMBER SERIES

Now we will know how to FILL any series of NUMBER in EXCEL.

It is very easy to FILL any series of NUMBER in EXCEL.


STEP -1 #   Whatever number of series we want to FILL, we have to put that DIFFERENCE in between the two NUMBERs of its opening. The DIFFERENCE that we will place in the first two NUMBER of any SERIES will be the same DIFFERENCE we will get after DRAG the entire NUMBER series.

For EXAMPLE we FILL a series of NUMBER with DIFFERENCE of 3 between every NUMBER, then we will put a DIFFERENCE of 3 between the two initial numbers. And after SELECTING those two NUMBERS together, we will DRAG it as far as we want that series and we get a series of 3 DIFFERENCE. (Here we take the first number 1 and the second number 4.)

ADVANCE FILLING AND AUTO FILLING
3 - FILL MONTH NAME AND DAY NAME

Now we will know how to FILL any series of NUMBER in EXCEL.

It is very easy to FILL any series of NUMBER in EXCEL.


STEP -1 #   Whatever number of series we want to FILL, we have to put that DIFFERENCE in between the two NUMBERs of its opening. The DIFFERENCE that we will place in the first two NUMBER of any SERIES will be the same DIFFERENCE we will get after DRAG the entire NUMBER series.

For EXAMPLE we FILL a series of NUMBER with DIFFERENCE of 3 between every NUMBER, then we will put a DIFFERENCE of 3 between the two initial numbers. And after SELECTING those two NUMBERS together, we will DRAG it as far as we want that series and we get a series of 3 DIFFERENCE. (Here we take the first number 1 and the second number 4.)

4 - CREATE CUSTOM LIST

So now we will learn how CUSTOM LIST is prepared in EXCEL.

The advantage of creating a CUSTOM list is that by creating a list of the names of employees in a large company, DRAG by writing the name of any one employee, the names of all the employees of the company get automatic.

So now we learn to make CUSTOM list.

STEP -1 #  First we will CLICK on FILE.

ADVANCE FILLING AND AUTO FILLING

STEP -2  # After that we will CLICK on OPTION.

STEP -3  # After that we will CLICK on ADVANCED.

STEP -4  # After that we will go below SCROLL BAR then CLICK on EDIT CUSTOM LIST.

STEP -5  # After that we will CLICK on NEW LIST and we will write whatever name we want to add to the list and CLICK on ADD in RIGHT SIDE.

ADVANCE FILLING AND AUTO FILLING

STEP -6  # After CLICK on ADD, we can USE CUSTOM LIST. For this, we write any one name and DRAG it by SELECT it, then we get our CUSTOM list.

So in this way we can make it our CUSTOM LIST and do it.

5- AUTO FILL

We will learn here how to fill any data easily very quickly.

STEP -1 # First of all we will write the DATA that we want to FILL. After that we will do the AREA SELECT in which we want to do DATA FILL.

For EXAMPLE, I write INDIA WORD here. And I do my AREA SELECT in which we have to do DATA FILL.

ADVANCE FILLING AND AUTO FILLING

STEP -2 # Next we want to fill DATA down (DOWN). So CTRL + D will press. So our DATA becomes FILL below.

Similarly, we want to fill the data in RIGHT SIDE. So CTRL + R will PRESS. So our DATA becomes FILL in RIGHT SIDE.

 

Similarly, we want to fill the data in RIGHT SIDE. So CTRL + R will PRESS. So our DATA becomes FILL in RIGHT SIDE.

ADVANCE FILLING AND AUTO FILLING

FOR MORE INFORMATION SEE THE VIDEO

Come see how much you learned in advance filling and auto filling

CLICK ON START QUIZ TO START THE QUIZ 

Leave a Reply

© 2020 NtOffice.in         ।     All Rights Reserved.

ABOUT US    ।    CONTACT   US   ।    TERMS  OF  USES   ।  DISCLAIMER   ।  PRIVACY  POLICY

WhatsApp
Google+
Facebook
Telegram