Now we will see how to work with working days (Except Saturday and Sunday). I hope you have understood the concept of autofill in excel. Suppose we need the dates from 1 st Jan 2019, just input and drag as usual. Input the required date from where you want subsequent dates. First, we will see how to automate dates, months and years. Now we will see how we can use this autofill in excel for dates. While dragging, you will not find the “+” sign cursor in the left corner it will be in the right corner only we just need to click on the right corner and drag it to our left side. We can find the below example, which dragged from right to left. In the above example, I dragged to my right hence, it shows as ‘Tue’ if I drag to my left, it will show as per that. It will not only apply in a Vertical way but can use this feature horizontally also. We have seen when I just input ‘Mon’ it still gives ‘Thu’. Suppose you are not good at spelling and lazy to enter an entire month or day just input the short form and drag. Input Monday and drag until required length it will fill the next days. This autofill feature is not only for the number but also for pattern texts like months and days.Īnd drag until the required length it will automatically fill the next months once we release the mouse. So, autofill in excel will apply for something of a similar pattern. Fill 9 and 18, then drag until the required number of cells it will give us the values of the 9 th table. Suppose we want to know the values of the 9 th table. Once we leave the mouse after dragging, the results will be like below.Īs shown above, we can perform for odd numbers. We can observe we have 2 and 4 in the spreadsheet when we drag three cells, it is showing value 10. It is not limited to the sequence of numbers, but you can use this auto-fill feature dragging of even or odd numbers like below.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |