1

00:00:00,580 --> 00:00:01,850

I love everybody.



2

00:00:01,950 --> 00:00:07,500

Let me now show you some of the under the hood tricks of autofill.



3

00:00:07,560 --> 00:00:14,070

Now if you intend to prepare a list of these which are going to show you the month endings for example



4

00:00:14,070 --> 00:00:17,350

three march them much 11:34 much trail.



5

00:00:17,760 --> 00:00:19,740

You don't need to write that by hand.



6

00:00:19,740 --> 00:00:20,230

No.



7

00:00:21,130 --> 00:00:23,710

Although you can to take some extra time.



8

00:00:23,710 --> 00:00:29,380

Instead you choose to sell the idea of giving the money and or the euro and they pulled it down using



9

00:00:29,410 --> 00:00:35,080

a different feature which is automatically enabled and from the given dropdown which is called to fill



10

00:00:35,170 --> 00:00:41,350

options to fill yours all the dates are now the month for March.



11

00:00:41,350 --> 00:00:42,980

For all the subsequent years.



12

00:00:43,120 --> 00:00:50,380

Similarly if you pull this data down and if you choose this time for months you get to see all the month



13

00:00:50,400 --> 00:00:51,140

end date.



14

00:00:51,340 --> 00:00:58,280

And it also captures automatically that 28 or 30 or 31 whichever's with the last B of the month.



15

00:00:58,510 --> 00:01:03,930

Not only that the ones in the tooth if you select both 1 and 2 and you pull this data down you know



16

00:01:03,960 --> 00:01:09,930

if you get getting a serial number for the alphanumeric data you simply write this down.



17

00:01:09,940 --> 00:01:13,060

And what you get and B-class 2010 2011.



18

00:01:13,090 --> 00:01:19,660

And so if you want to have an alphanumeric list being prepared with a defined interval class for example



19

00:01:19,760 --> 00:01:26,630

or maybe I wanted to create some batch numbers so that it's under 100 CDs that it's 1 0 200 CDs select



20

00:01:26,710 --> 00:01:27,450

both of them.



21

00:01:27,520 --> 00:01:33,480

And as you drive both of them know what you get they are in the defined series of hundred Interbrand.



22

00:01:33,590 --> 00:01:37,640

Now these are some of the intermediate level of autofill tricks.



23

00:01:37,870 --> 00:01:42,950

Well now let me share with you one more tricks which you would not have encountered by now.



24

00:01:43,870 --> 00:01:49,850

Let's in this case I have a new report and that other girl entering mentioned in two says one of another.



25

00:01:50,230 --> 00:01:56,870

I wish that this 2012 13 should be pasted here automatically without much of copy and pasting.



26

00:01:56,940 --> 00:01:58,360

Now watch this.



27

00:01:58,420 --> 00:01:59,940

Choose both of these cells.



28

00:02:00,100 --> 00:02:01,080

Go to home dad.



29

00:02:01,240 --> 00:02:07,060

And from the fill feature on the right side choose justified.



30

00:02:07,090 --> 00:02:09,030

Notice how they both get combined.



31

00:02:09,280 --> 00:02:15,940

LOL This only works if you have given enough vent to the starting cell so that it can accommodate the



32

00:02:15,940 --> 00:02:17,210

next cell value.



33

00:02:17,230 --> 00:02:24,320

If I give the column to Liberty and then populate the same procedure fail justify it doesn't work.



34

00:02:24,490 --> 00:02:29,890

So for one of those two or three of these up there you might have an audible detail in alcoholism and



35

00:02:29,890 --> 00:02:31,480

you might have a gun let's.



36

00:02:31,690 --> 00:02:36,340

EBC in and you will combine all the three in one cell.



37

00:02:36,460 --> 00:02:38,430

You mention the column that is wide enough.



38

00:02:38,560 --> 00:02:44,370

Then go home then go to fail and then go to justify grop.



39

00:02:44,620 --> 00:02:45,970

That's what the tricked us.