I love everybody.
Let me now show you some of the under the hood tricks of autofill.
Now if you intend to prepare a list of these which are going to show you the month endings for example
three march them much 11:34 much trail.
You don't need to write that by hand.
No.
Although you can to take some extra time.
Instead you choose to sell the idea of giving the money and or the euro and they pulled it down using
a different feature which is automatically enabled and from the given dropdown which is called to fill
options to fill yours all the dates are now the month for March.
For all the subsequent years.
Similarly if you pull this data down and if you choose this time for months you get to see all the month
end date.
And it also captures automatically that 28 or 30 or 31 whichever's with the last B of the month.
Not only that the ones in the tooth if you select both 1 and 2 and you pull this data down you know
if you get getting a serial number for the alphanumeric data you simply write this down.
And what you get and B-class 2010 2011.
And so if you want to have an alphanumeric list being prepared with a defined interval class for example
or maybe I wanted to create some batch numbers so that it's under 100 CDs that it's 1 0 200 CDs select
both of them.
And as you drive both of them know what you get they are in the defined series of hundred Interbrand.
Now these are some of the intermediate level of autofill tricks.
Well now let me share with you one more tricks which you would not have encountered by now.
Let's in this case I have a new report and that other girl entering mentioned in two says one of another.
I wish that this 2012 13 should be pasted here automatically without much of copy and pasting.
Now watch this.
Choose both of these cells.
Go to home dad.
And from the fill feature on the right side choose justified.
Notice how they both get combined.
LOL This only works if you have given enough vent to the starting cell so that it can accommodate the
next cell value.
If I give the column to Liberty and then populate the same procedure fail justify it doesn't work.
So for one of those two or three of these up there you might have an audible detail in alcoholism and
you might have a gun let's.
EBC in and you will combine all the three in one cell.
You mention the column that is wide enough.
Then go home then go to fail and then go to justify grop.
That's what the tricked us.