AutoFill – Automatically write Dates, Months, Years in Excel in Hindi
Automatically repeat values that already exist in the column If the first few characters that you type in a cell match an existing entry in that column, Excel automatically enters the remaining characters for you. Excel automatically completes only those entries that contain text or a combination of text and numbers. Entries that contain only numbers, dates, or times are not automatically completed.
Using the fill handle, you can quickly fill cells in a range with a series of numbers or dates, or with a built-in series for days, weekdays, months, or years.