Formats Affect Excel’s Fill Handle

Applying a date format before you drag with the Fill Handle may save you some time. See why.

The two cells in the image below have the same entry – 1/1/23.

But when you drag them with the Fill Handle the results are different. See the image below.

When the format displays the month and year as in cell B1, the Fill Handle increments by month.

Normal dates increment by day as per column A.

(Note these dates are in the dd/mm/yyyy format.)

If you want to drag months apply the format first and then drag.

The mmm-yy format is common, so it can be worth creating a Style to apply it.

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.