BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
Some tasks in Excel always seem to take longer than they should - if only you knew a bunch of quick shortcuts to speed up the simple things. Read on to see how much time you could save!
- Excel Quick Tip #1 - Copying a Formula
- Excel Quick Tip #2 - Putting Dollar Signs in a Formula
- Excel Quick Tip #3 - Adding Totals to Columns
- Excel Quick Tip #4 - Selecting a Table
- Excel Quick Tip #5 - Sorting a List
- Excel Quick Tip #6 - Creating Range Names
- Excel Quick Tip #7 - Creating a Chart
- Excel Quick Tip #8 - Copying a Worksheet
- Excel Quick Tip #9 - Entering Today's Date
- Excel Quick Tip #10 - Copying Days and Months (this blog)
Posted by Andrew Gould on 02 December 2011
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Excel Quick Tip #10 - Copying Days and Months
When you need a series of weekday names or month names you don't have to laboriously type in each one. Just enter the starting day or month and let the AutoFill Handle do the rest!
- Type in the starting day or month name and then select that cell.
![]() |
![]() |
The first day | The first month |
- Click and drag on the AutoFill handle to fill a series of day or month names.
![]() |
![]() |
The series of days | The series of months |
You can do the same thing with short day and month names. Try starting a list with Mon or Jan.
You can watch a video of this technique at Wise Owl's YouTube channel.
- Excel Quick Tip #1 - Copying a Formula
- Excel Quick Tip #2 - Putting Dollar Signs in a Formula
- Excel Quick Tip #3 - Adding Totals to Columns
- Excel Quick Tip #4 - Selecting a Table
- Excel Quick Tip #5 - Sorting a List
- Excel Quick Tip #6 - Creating Range Names
- Excel Quick Tip #7 - Creating a Chart
- Excel Quick Tip #8 - Copying a Worksheet
- Excel Quick Tip #9 - Entering Today's Date
- Excel Quick Tip #10 - Copying Days and Months (this blog)