0306 Cell Drag-n-drop Auto Fill Options - Yr-end, Month-end, AlphaNumeric, Fill - Justify

2 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.21
You save:  د.إ146.92
List Price:  A$189.27
You save:  A$54.08
List Price:  ৳11,874.45
You save:  ৳3,392.94
List Price:  CA$174.19
You save:  CA$49.77
CHF 90.63
List Price:  CHF 126.88
You save:  CHF 36.25
List Price:  kr876.09
You save:  kr250.33
List Price:  €117.79
You save:  €33.65
List Price:  £100.24
You save:  £28.64
List Price:  HK$1,087.91
You save:  HK$310.85
List Price:  ₹10,396.08
You save:  ₹2,970.52
List Price:  RM592.78
You save:  RM169.38
List Price:  ₦57,615.03
You save:  ₦16,462.61
List Price:  kr1,223.76
You save:  kr349.67
List Price:  NZ$199.75
You save:  NZ$57.07
List Price:  ₱7,023.18
You save:  ₱2,006.76
List Price:  ₨22,717.01
You save:  ₨6,491.03
List Price:  S$189.41
You save:  S$54.12
List Price:  ฿4,598.67
You save:  ฿1,314
List Price:  ₺1,183.81
You save:  ₺338.25
List Price:  B$707.83
You save:  B$202.25
List Price:  R2,037.17
You save:  R582.09
List Price:  Лв230.32
You save:  Лв65.81
List Price:  ₩160,005.91
You save:  ₩45,719.24
List Price:  ₪453.71
You save:  ₪129.64
Already have an account? Log In


Hello, everybody. Let me now show you some of the under the hood tricks of autofill. Now, if you intend to prepare a list of dates, which is going to show you the month end dates, for example, 31st, March 10 31st, March 11 31st, March 12. You don't need to write that by hand. Nope. Although you can, but it's going to take some extra time.

Instead, you choose a cell where you have given the month end or the year end date, pull it down using autofill feature which is automatically enabled. And from the given drop down, which is called autofill options, choose fill yours all the dates are now the month end for March for all the subsequent years. Similarly, if you pull this data down, and if you choose this time fill months, you get to see all month end dates, and it also captures automatically that 28 or 30 or 31, whichever will be the last day of the month. Not only that the ones in If you select both one and two, and you pull this data down, you notice you get getting a serial numbered list for the alphanumeric data, you may simply digest down and what do you get me class 2010 2011 and so on. If you want to have an alphanumeric list being prepared with a defined interval class, for example, maybe I want to create some batch numbers.

So that x 101 hundred series Zed x 102 hundred series, select both of them. And as you drag both of them notice what you get, they are in the defined series of hundred interval. Now these are some of the intermediate level of autofill tricks. Well, now let me share with you one more tricks which you will not have encountered by now. Let's see in this case, I have an old report in 2012 and 13, mentioned in two cells one after 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 tab. And from the film feature on the right hand side, choose justify. Notice how they both get combined? Well, this only works if you have given enough weight to the starting cell so that it can accommodate the next cell value.

So if I keep the column width limited, and then I populate the same procedure fill, justify, it doesn't work. So for one of those two or three of data, where you might have annual report 2012 13, and you might have a company let's say, ABC, Inc. and you want to combine all the three in one cell, you made sure the column width is wide enough, then go to home, then go to fill, and then go to justify go. That's what the trick does.

Sign Up


Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.