Excel: formula to get auto serial, day, month and year

Excel: formula to get auto serial, day, month and year

Hi Kbe123,

Yes, there is a fast and easy way to do auto serial for either the day, month or year in Excel. If you did not know, Excel has a built in feature that tries to anticipate what you are trying to do and will do it automatically for you. This is quite helpful such as in your case where you have to do a lot of typing of data.

Let's say for example, you want to input numbers in a list from 1 to 50. The normal way of doing this would be to input each number in each cell one at a time. This process not only takes you a lot of time to do but can also be quite stressful. The easier method of accomplishing this task is to first make a pattern that you want Excel to follow.

So the first step is to input two numbers, one in each, this will be your pattern. It should look something like this.

The next step is to highlight the numbers starting from the first cell going down to the next. Next thing you have to do is to click on the little square box that can be seen on the lower right hand side of the cells you highlighted. The little square box has been circled in the image below.

The last step is to simply drag down until you reach 50 while you click and hold on the little square box. Once completed, you should have something that looks like this.

This process can be repeated when you wish to create lists that are incremental. The days of the week, months, and also years can be done with this technique as well.

Hope this helps you out.