WiseOwl Training - Established 1992
COVID-19: Choose between our familiar (but now socially distanced) classroom training courses and our excellent new live online courses.
This page has 0 threads   |  Add post
Five star reviews Outstanding course feedback
Average score 9.32 out of 10, based on 8935 reviews
If you found this blog useful and you’d like to say thanks you can click here to make a contribution. Thanks for looking at our blogs!

BLOGS BY TOPIC

BLOGS BY AUTHOR

BLOGS BY YEAR

10 Excel Quick Tips
Part ten of a ten-part series of blogs

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!

  1. Excel Quick Tip #1 - Copying a Formula
  2. Excel Quick Tip #2 - Putting Dollar Signs in a Formula
  3. Excel Quick Tip #3 - Adding Totals to Columns
  4. Excel Quick Tip #4 - Selecting a Table
  5. Excel Quick Tip #5 - Sorting a List
  6. Excel Quick Tip #6 - Creating Range Names
  7. Excel Quick Tip #7 - Creating a Chart
  8. Excel Quick Tip #8 - Copying a Worksheet
  9. Excel Quick Tip #9 - Entering Today's Date
  10. 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!

  1. Type in the starting day or month name and then select that cell.
Day name Month name
The first day The first month
  1. Click and drag on the AutoFill handle to fill a series of day or month names.
Day series Month series
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.

  1. Excel Quick Tip #1 - Copying a Formula
  2. Excel Quick Tip #2 - Putting Dollar Signs in a Formula
  3. Excel Quick Tip #3 - Adding Totals to Columns
  4. Excel Quick Tip #4 - Selecting a Table
  5. Excel Quick Tip #5 - Sorting a List
  6. Excel Quick Tip #6 - Creating Range Names
  7. Excel Quick Tip #7 - Creating a Chart
  8. Excel Quick Tip #8 - Copying a Worksheet
  9. Excel Quick Tip #9 - Entering Today's Date
  10. Excel Quick Tip #10 - Copying Days and Months (this blog)
This blog has 0 threads Add post