Tips and tricks in excel.
Working with data in excel sometime we tend to auto fill columns or rows with data. Using Autofill handler, we can fill series of Dates
Lets us try example to autofill first date of upcoming months. In below GIF image I have entered dates of two months.
Once both the dates are selected, hold down the right button on mouse and drag downwards.
Release the button, you will see autofill Pop-up menu in front of you.
Select "Fill Months" on Pop-up menu and you will get the result with dates in selected range.
Even you can select "Fill Series" option on menu.
No comments:
Post a Comment