Contextures News

Quick List of Months in Excel

June 21, 2016

Create a quick list of months or weekdays, and more, in this week's Excel news. If there are topics that you'd like to see covered in future newsletters, please let me know.

 -  Debra -  ddalgleish @
     Visit my Excel website for many more tutorials and videos.

Quick List of Months or Weekdays

This trick is easy, and a real time-saver. If you're setting up a worksheet, you might need a list of months or weekdays, so you can start entering data for those dates. To quickly make a list, type the first date on the worksheet. Then, select that cell, and point to the little black square in its bottom right corner.

Instead of pressing the left mouse button, press the RIGHT mouse button, and drag down, as far as you need to. Let go of the mouse button, then click one of the options in the popup list. For example, click Fill Months, or my favourite, Fill Weekdays.

You can get more quick data entry tips on my website.

create a list of months

Excel VBA Master Course

Do you enjoy using Excel VBA to create macro for yourself or your co-workers or clients? Maybe you're self-taught, learning from a book or two, Google searches, and lots of painful experience (like me!). If you'd like a great opportunity to quickly improve your VBA skills, take a look at the Excel VBA Master Class that will be held in Amsterdam, on October 26-27. This two-day course should quickly pay for itself, in the time that you'll save in writing and troubleshooting your code.

Registration just opened, and the class size is limited. There is an Early Bird discount, if you register before July 31st. (On the "Select Ticket" page, click the button that shows the number remaining, then choose the Early Bird ticket.)

Excel Articles

Here are a couple of Excel articles I read recently, that you might find useful.

Hidden Features -- Charley Kyd shows how to find and use some of Excel's best hidden features. Note: To add the New command, and a few others, just click the arrow at the end of the QAT, then add a check mark to one of the commands in the list. (Level - All)

Bullet Chart -- Jorge Camoes gives step by step instructions on how to build a bullet chart in Excel. These are very compact charts that are great to use on a dashboard. (Level - Intermediate/Advanced)

More Excel Articles -- Visit my Excel website for many more tutorials and videos. And for a bit of fun, read my weekly collection of entertaining Excel tweets.

Smell the Roses

If you saw the science project picture last week, I have good news to report. My grandson called to say that his teacher loved it! Phew! I took it easy this week though, and spent some time relaxing in the garden, enjoying the lovely roses. They come back to brighten the yard year after year, and thrive despite my neglect.

NOTE: If you have any problems with the links in the email, you can see this newsletter on my website -- copy this link and paste it into your browser:

Recommended Excel Products

  • FastExcel: Watch the short video on my website to see how these tools help you manage your Excel files, identify calculation jams, and remove or reduce the problems. If you work with large, calculation-heavy Excel files, FastExcel is a great investment.
  • Excel Chart Tools: If you build complex charts, save time with Jon Peltier's Excel Charting add-in. Don't waste hours trying to format the chart yourself!


Choose Your Excel News: Get the full Contextures news package, or the basic one. To change, click a link below, and use the sign-up form on that page.

  • Full News Package: Weekly newsletter, plus occasional emails so you won't miss out on special Excel deals, free webinars, new products, and other Excel news.

Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.



Last updated: May 24, 2021 7:59 PM