00:00And it's time for us to automate data filling.
00:04What does automatic filling mean? We start by telling the program
00:08Write us your data automatically to save us time and effort.
00:13For example, I want to create a series of numbers to write data in this series.
00:18So he started writing one, then two, and then three.
00:22Can I have it auto-fill the data or numbers in my range?
00:28Okay, if I want, for example, to have him write this information for me in a specific way
00:34For example, between each cell and cell, it will add two numbers, for example, it will add three, it will add five.
00:40Well, I want the direction to be, for example, up, down, right, left, whatever it is. How do I do this?
00:46Come on, let's see, one by one, if I want to do an automatic filling
00:52First, I might like this data to be repeated only for me.
00:56So I start by seeing the trend, for example, repeating itself with me below.
01:00My sheet is Arabic, of course, from right to left.
01:04So I started standing on the cell from below, opposite to the direction of the sheet.
01:09The sheet from right to left remains I will stop the cell to the north
01:12From under my gifts, I have a black plus sign, if it appears in the photo with you.
01:17And pull down this one, it will be repeated
01:21Ok, no, I don't want to make one for myself. I want it to be an Arkham series.
01:25So I stopped in the same way and the black one appeared to me.
01:29But I want to increase my accumulation
01:32Press the control button on the keyboard
01:37And pull down
01:39We notice that I work on the Arkham series
01:42Ok, very nice
01:44I'm either working on an Arkham series or filling out data entry
01:48Ok, if I want the data to be on the left side, I will specify it on the left side.
01:53And I will go from the main ribbon tab and tell him to fill here
01:57left
01:59What does the one on the left do to me?
02:03Ok, I want this one on the right. I will specify the range in which I want one to write.
02:08I will tell him to swear
02:11I want it down and I'll come like this
02:15And I will tell him down
02:17And so on
02:19Ok, I would like him to make me an Arkham series, for example.
02:22There is a certain difference between them, so I will do this.
02:25I will specify my range and tell him to fill it up.
02:27For example, I will have the value of the mistake.
02:31I mean, how much does it increase between each one and the other?
02:33For example, here you go
02:35five
02:36The stop value is twenty-five.
02:38Let's take care here if I am limited to empty water
02:41But when I have twenty-five, it's time to stop.
02:43Okay, it will stop at number twenty-five.
02:45He has nothing to do with the behavior I have specified, so tell him I agree.
02:49You see?
02:51One more, six more
02:53eleven sixteen twenty-one
02:55Of course, twenty-five is not appropriate for her, because if five is added, it will be twenty-six.
02:59It stops at twenty-one
03:01Ok, let's try it again. We'll decide here.
03:05I will tell him to fill the chain
03:09Let it be worth eight, for example.
03:15And the value of the stoppage began, I told him, “Okay.”
03:21Can I make it history?
03:23Date, for example, twelve thousand nine hundred and twenty
03:27I specify and tell him to fill up
03:31series
03:33Can I leave it like this?
03:35Step 3 chemistry
03:37Can I make it a working day, a month or a year?
03:39Let it be for a month
03:41Two step chemistry
03:43So he can give me two months and I can tell him I agree
03:45It starts here
03:47Provides two months
03:49Every time
03:51Here I consider that this nine is the month
03:57So, there remained a month, nine, a month, twelve, one, a month, three, five, seven, nine, eleven, one, and so on.
04:03This way we fill our containers in a very easy and simple way. Come on, try it.
04:09War rifle
04:11ill
04:17behind
04:19Now I'm bored
04:20second
04:21behind
Comments