---
title: How to automatically fill a column with days of the week in Excel
description: How to automatically fill a column with days of the week in Excel
image: https://www.connysoderholm.com/hubfs/Imported_Blog_Media/main-qimg-0f8784c4d1da599e5fa55a6f74f6f7b1.png
---

[Skip to content](https://www.connysoderholm.com/blog/how-to-automatically-fill-a-column-with-days-of-the-week-in-excel#main-content)

![Conny-Söderholm](https://www.connysoderholm.com/hubfs/Conny-S%C3%B6derholm.svg)

- [Home](https://www.connysoderholm.com/)
- [Courses](https://www.connysoderholm.com/courses)
- [Articles](https://www.connysoderholm.com/blog)
- [Contact Me](https://www.connysoderholm.com/contact-me)

Open main navigation

Close main navigation

- [Home](https://www.connysoderholm.com/)
- [Courses](https://www.connysoderholm.com/courses)
- [Articles](https://www.connysoderholm.com/blog)
- [Contact Me](https://www.connysoderholm.com/contact-me)

 December 27, 2019

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

![Picture of Conny Söderholm](https://app.hubspot.com/settings/avatar/c60eb763b898c1f4c2e54f9401f3aef1) [Conny Söderholm](https://www.connysoderholm.com/blog/author/conny-soderholm)

Share: [facebook-f icon](http://www.facebook.com/share.php?u=https://www.connysoderholm.com/blog/how-to-automatically-fill-a-column-with-days-of-the-week-in-excel) [linkedin-in icon](http://www.linkedin.com/shareArticle?mini=true&url=https://www.connysoderholm.com/blog/how-to-automatically-fill-a-column-with-days-of-the-week-in-excel) [Twitter icon](https://twitter.com/intent/tweet?url=https://www.connysoderholm.com/blog/how-to-automatically-fill-a-column-with-days-of-the-week-in-excel) [pinterest-p icon](http://pinterest.com/pin/create/link/?url=https://www.connysoderholm.com/blog/how-to-automatically-fill-a-column-with-days-of-the-week-in-excel) [envelope icon](mailto:?body=https://www.connysoderholm.com/blog/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.

![](https://www.connysoderholm.com/hubfs/Imported_Blog_Media/main-qimg-0f8784c4d1da599e5fa55a6f74f6f7b1.png)

Select the fill handle.

![](https://www.connysoderholm.com/hubfs/Imported_Blog_Media/main-qimg-19d6da2051670483bcc2d1bc98aaca20.png)

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](http://www.youtube.com/watch?v=2RPrMLSXo1A). I also embedded the video in this post.

![](https://www.connysoderholm.com/hubfs/Imported_Blog_Media/main-qimg-ac576f937da46fdbf11c169af1223f0a.png)

 

[Excel](https://www.connysoderholm.com/blog/tag/excel)

## Related posts

[Python](https://www.connysoderholm.com/blog/tag/python), [openpyxl](https://www.connysoderholm.com/blog/tag/openpyxl), [Excel](https://www.connysoderholm.com/blog/tag/excel)

## [Transpose or rotate Excel cell data with OpenPyXL](https://www.connysoderholm.com/blog/transpose-or-rotate-excel-cell-data-with-openpyxl)

![Picture of Conny Söderholm](https://app.hubspot.com/settings/avatar/c60eb763b898c1f4c2e54f9401f3aef1) [Conny Söderholm](https://www.connysoderholm.com/blog/author/conny-soderholm) 

 December 28, 2019

[Read more](https://www.connysoderholm.com/blog/transpose-or-rotate-excel-cell-data-with-openpyxl)

[Python](https://www.connysoderholm.com/blog/tag/python), [openpyxl](https://www.connysoderholm.com/blog/tag/openpyxl), [Excel](https://www.connysoderholm.com/blog/tag/excel)

## [Copy Excel data to workbook with Python & OpenPyXL](https://www.connysoderholm.com/blog/copy-data-from-one-excel-workbook-to-a-new-workbook-with-python-openpyxl)

![Picture of Conny Söderholm](https://app.hubspot.com/settings/avatar/c60eb763b898c1f4c2e54f9401f3aef1) [Conny Söderholm](https://www.connysoderholm.com/blog/author/conny-soderholm) 

 December 16, 2019

[Read more](https://www.connysoderholm.com/blog/copy-data-from-one-excel-workbook-to-a-new-workbook-with-python-openpyxl)

[Python](https://www.connysoderholm.com/blog/tag/python)

## [Saying Hello World with tkinter](https://www.connysoderholm.com/blog/hello-world-tkinter)

![Picture of Conny Söderholm](https://app.hubspot.com/settings/avatar/c60eb763b898c1f4c2e54f9401f3aef1) [Conny Söderholm](https://www.connysoderholm.com/blog/author/conny-soderholm) 

 June 4, 2018

I have always wanted to build Graphical User Interface (GUI) applications but felt that the...

[Read more](https://www.connysoderholm.com/blog/hello-world-tkinter)

[linkedin-in icon](https://www.linkedin.com/in/connysoderholm) [Follow us on Facebook](https://www.youtube.com/@connysoderholm1473)

- [Home](https://www.connysoderholm.com)
- [Courses](https://www.connysoderholm.com/courses)
- [Articles](https://www.connysoderholm.com/blog)
- [Contact Me](https://www.connysoderholm.com/contact-me)
- [Privacy Policy](https://www.connysoderholm.com/privacy-policy)
- [Disclaimer](https://www.connysoderholm.com/disclaimer)

---

[![Conny Söderholm Logo](https://www.connysoderholm.com/hubfs/Conny-S%C3%B6derholm.svg "Conny Söderholm Logo")](http://Conny%20Söderholm)

Copyright © 2026 Conny Söderholm

```json
{
  "@context" : "https://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Conny Söderholm",
    "url" : "https://www.connysoderholm.com/blog/author/conny-soderholm"
  },
  "dateModified" : "2023-07-31T15:13:46.703Z",
  "datePublished" : "2019-12-27T19:13:39.000Z",
  "headline" : "How to automatically fill a column with days of the week in Excel",
  "image" : [ "https://www.connysoderholm.com/hubfs/Imported_Blog_Media/main-qimg-0f8784c4d1da599e5fa55a6f74f6f7b1.png" ],
  "mainEntityOfPage" : {
    "@id" : "https://www.connysoderholm.com/blog/how-to-automatically-fill-a-column-with-days-of-the-week-in-excel",
    "@type" : "WebPage"
  },
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "url" : "https://www.connysoderholm.com/hubfs/Conny-S%C3%B6derholm.svg"
    },
    "name" : "Conny Söderholm"
  }
}
```