27.12.2019

How to automatically fill a column with days of the week in Excel

To autofill a column with weekdays in Excel we do not need any shortcuts at all.

Write the day you want to start from in one of your cells. Let’s start on Monday.

Select the fill handle.

Drag the cell down as many days as you like. Excel will automatically fill your days in the cells. You can start with whatever day you like.

I have also made a video that you can find here if you prefer: How to automatically fill a column with days of the week in Excel. The video is also embedded in this post.

Leave a Reply

Your email address will not be published.

linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram