0305 Cell Drag-n-drop Auto Fill Options + Activation Setting

1 minutes
Share the link to this page
You need to purchase the class to view this lesson.
One-time Purchase
List Price:  $139.99
You save:  $40
List Price:  د.إ514.18
You save:  د.إ146.92
List Price:  A$195.60
You save:  A$55.89
List Price:  ৳11,872.36
You save:  ৳3,392.34
List Price:  CA$187.37
You save:  CA$53.54
CHF 91.26
List Price:  CHF 127.77
You save:  CHF 36.51
List Price:  kr884.75
You save:  kr252.80
List Price:  €118.74
You save:  €33.93
List Price:  £107.27
You save:  £30.65
List Price:  HK$1,084.99
You save:  HK$310.02
List Price:  ₹10,502.85
You save:  ₹3,001.03
List Price:  RM586.20
You save:  RM167.50
List Price:  ₦52,986.21
You save:  ₦15,140
List Price:  kr1,265.84
You save:  kr361.69
List Price:  NZ$211.96
You save:  NZ$60.56
List Price:  ₱6,870.27
You save:  ₱1,963.07
List Price:  ₨23,504.32
You save:  ₨6,716
List Price:  S$192.17
You save:  S$54.91
List Price:  ฿4,370.86
You save:  ฿1,248.90
List Price:  ₺1,021.10
You save:  ₺291.76
List Price:  R2,469.09
You save:  R705.50
Already have an account? Log In


Hello everybody. In this video session we'll talk about autofill option. At the basic level, you would have already encountered this phenomenon in Excel that if you pull any date down, you get sequential date. And in fact, if you write a weekday, let's say Monday and you pull that down, you get the similar phenomenon monday, tuesday till the next day. And same goes for month, Jan, all January. If I pull that information down, I get the sequential data.

Now, this was the basic autofill feature. Now before I proceed, let me ensure that you all have enabled this feature. Now nine out of 10 times this will already be enabled by default, but in case you're not able to pull any data down the way I have shown, then you must go to excel option. So in the current version of Excel file, I go to options there, I go to Advanced tab, and within advanced you'll notice there's one section which says enable fill handle. So this must be turned on If it is not turned on, you will not be able to drag this and benefit out of this feature. So this was enabling autofill feature.

In the next video of autofill. I will show you the other variations of autofill which are super important, especially if you're working with dates. You're working with serial numbers and if you're working with alphanumeric data

Sign Up