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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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