Autofill Dates, Months And Current Time in Excel Sheet

In this tutorial, learn how to add or autofill dates, months and today’s current time in MS Excel Sheet with the step-by-step process here. There are many date format which you can enter in the cell.

All date formats are not the valid formats which you can use to autofill. To autofill your dates, you have to use the below guide. The guide contains the various step-by-step process to autofill required dates, months and the current time.

Learn with the steps and screenshots to understand each step visually. So, let’s start learning with the filling of dates.

How to Autofill Dates in Excel Sheet

The date format contains the months in numeric format. However, you can also use the alphabetical format of months in the dates. To autofill the dates. see the guide given below.

Autofill Dates Showing Numeric Months in Excel

The numeric date format can be auto-filled using the below steps. Follow each step and use on your Excel sheet.

Step 1. Enter the Date

First of all, enter the date as the format given in the image below. perhaps, you are not familiar with the date format to fill in the cell. Use the current date with the simple keyboard shortcut.

Autofill Dates Enter the date

You have to press the keyboard shortcut ctrl+; to get the current date. The output date is the required format which you have to use to autofill the dates.

Step 2. Click The Indicated Place and Hold Mouse Left Button

After you get the required numeric date format, you have to take you to mouse to the indicated place given in the image. When you take your mouse to the indicated place, you will get a plus(+) sign pointer.

Autofill Dates Click The Indicated Place and Hold Mouse Left Button

You have to now click and hold the left mouse button and follow the next step.

Step 3. Drag-down to Fill Date

While holding the mouse left button, drag your mouse towards downward direction. You will get filled dates in the selected cells of the Excel sheet.

Autofill dates Drag-down to Fill Date

The above example shows the dates filled from cell B2 to B10. However, you can drag down to more cells to fill more dates as per your requirement.

Alphabetical Months Showing Dates in Excel

In addition to numeric date format, you can also autofill dates in alphabetical month format. To fill the date with alphabetical months, follow the step-by-step process given below.

Step 1. Enter the date With Alphabet Format

There are many formats of dates with alphabet months. Below date format given in the image is our tested format. However, you can try more format and follow the steps to autofill dates.

Autofill Dates Enter the date With Alphabet Format

Fill any cell with the above date format and follow the next step.

Step 2. Click The Indicated Place and Hold Mouse Left Button

You have to now click the indicated place as given in the image below. The indicated place gives you a plus(+) sign on hover over the place.

Autofill Dates Click The Indicated Place and Hold Mouse Left Button

Hold your mouse after a click on the indicated place. Check the next step to complete filling the dates.

Step 3. Drag-down to Fill Date In Alphabet Format

Drag your mouse to the downward to fill the dates. The dates get automatically filled in the reached cells of the Excel sheet.

Autofill Dates Drag-down to autoFill Dates In Alphabet Format

You have to drag your mouse till you reach the last required cell. The above image shows the dates with the alphabetical format month to fill.

Add Odd Number Dates in Excel

The odd number dates contain the odd number days. Here, you will learn how to autofill the odd number dates with the step-by-step guide below.

Step 1. Enter Odd Number Dates In Two Cells

You have to first enter the two sequence odd dates in two cells. The example in the image below showing the two odd dates.

Autofill Dates Enter Odd Number Dates In Two Cells

Step 2. Select Two Cells

After entering the dates, you have to select the two dates using the shift and arrow key of the keyboard. If you select only the single cell, you cannot autofill odd dates in the Excel sheet.

Select Two Cells

The above image showing the two selected odd dates. You can enter any other sequence of cells as per your requirement.

Step 3. Click Indicated Place and Hold Mouse Left Button

Now, go to the indicated place as given in the image below. A plus(+) sign will starts to appear and you have to click and hold your mouse left button.

Click Indicated Place and Hold Mouse Left Button

Keep holding your mouse and follow the next step to autofill dates.

Step 4. Drag-down to Add and Get Odd Number Dates

While holding your mouse, drag-down to the cell which is the end cell to autofill odd dates. You can autofill as many cells as you want to get.

Drag-down to Add and Get Odd Number Dates

The above example showing the filled cells with odd dates. You can add your own dates with the above-given steps.

Show Even Number Dates in Excel

In addition to autofill odd dates, you can also autofill even date with the step-by-step process given here. Follow each step given below and if you feel any difficulty, you can see the screenshots also given with each step.

Step 1. Put Even Number Dates In Two Cells

You have to first put two sequence even dates in the two cells. You can use any sequence of even dates as per your requirement.

Put Even Number Dates In Two Cells

The above example image showing the two sequence of even dates. If you want to learn the process, you can try the same inputs in the two cell. After you understand the process, you can put your own required input to autofill even dates.

Step 2. Select Two Filled Cells

Now, select these two cells filled with even dates. To select the cells, you have to use the keyboard shift key and arrow key.

Select Two Filled Cells

The above example image showing the two selected cells with even dates.

Step 3. Click Indicated Place and Hold Mouse Left Button

After selecting the cells, you have to go to the indicated place given in the image. A plus(+) sign starts appearing where you have to click and hold mouse left button.

Click Indicated Place and Hold Mouse Left Button

The above image showing the indicated place which you have to use.

Step 4. Drag Your Mouse Downward to Get Even Dates

Keep dragging your mouse to the downward direction. Even dates start filling in the dragged cells you reach. You can fill as many cells as you want even dates.

Drag Your Mouse Downward to Get Even Dates

The above image showing the auto-filled even dates in the cells from B2 to B12.

Autofill Months in Microsoft Excel

In addition to the above dates, you can also autofill months using the steps given below. You can fill months in sequence or with increasing by two.

Add Months in Excel

To fill the sequence of months in the required number of cells continuously. You have to use the below-given methods given with screenshots.

Step 1. Enter Month in a Cell

First of all, fill any cell with the start month name. Suppose, you have to start the month from January.

Autofill months Enter Month in a Cell

You can fill the cell with Jan as given in the image above

Step 2. Click the Indicated Place and Hold Mouse Left Button

After entering the month in the required cell. You have to click the indicated place and hold your mouse left button.

Autofill months Click the Indicated Place and Hold Mouse Left Button

The above image showing the indicated place which you have to click. Also, keep holding your mouse left button for the next step.

Step 3. Drag-down to Get Months

While you keep holding your mouse, drag your mouse till the cell you want to autofill with month. You can autofill the number of the cell using this method.

Autofill months Drag-down to Get Months

The above showing the auto-filled with the sequence of months in Excel sheet.

Display Months With Increasing By Two

You can also autofill month with increasing by Two. For example, you can start with the month Jan and the next sequence of the month is Mar. This shows that the months differ with two. See the below steps to fill with an increase by two.

Step 1. Put Two Months With Second Increasing By Two

Enter two months with difference of two as given in the image below. You can change the month names as per your requirement.

Autofill months Display Months With Increasing By Two

The image showing the entered months in the two cells.

Step 2.Select Two Months

You have to now select the two months you are entered in the previous steps. To select the months, you can use the mouse or the keyboard shift key with the arrow key.

Autofill months

The above image showing the two selected cells filled with the months.

Step 3. Click Indicated Place and Hold Mouse Left Button

The below image showing the indicated place which you have to use. Use the left mouse button to click the indicated place. You can see the plus(+) sign where you click and hold the mouse button for the next step.

Autofill months Click Indicated Place and Hold Mouse Left Button

The above image indicated the location where you have to take your mouse for the plus(+) sign.

Step 4. Drag The Mouse Towards Downward to Get Months Increasing By Two

This is the last step where you have to drag your mouse while keep holding mouse left button. Drag-down mouse till you reach the required cell to autofill.

Autofill months Drag The Mouse Towards Downward to Get Months Increasing By Two

Check the above image showing the months with each month increase by two.

Automatically Get Current Date in Excel Sheet

In Microsoft Excel Sheet, you can get the current date with just pressing of the keyboard shortcut. Press keyboard shortcut ctrl + ; in the cell where you want to add the current date.

On pressing of the shortcut, current prints automatically on the selected cell.

Get Current Date in Excel Sheet

The above image showing the cell containing the current date.

Display and Get Current Time in Excel

In addition to getting the current date, you can also get current time using keyboard shortcut in Excel. You have to press the keyboard shortcut ctrl + shift + ; to get the current time.

You will get the time showing AM or PM as per your current time.

Display and Get Current Time in Excel

The above example image showing the current time when we have created this tutorial post.

You may also like to read

Reference
MS Office Support Docs