Monday, February 5, 2018

Later, Alligator…

At over 9 years old, Excel Enthusiasts has been one of the longest running blogs on the Internet. It is time to move on, however, so if you Subscribe to this blog on Amazon Kindle, Please CANCEL YOUR SUBSCRIPTION this week!

Thanks so much for reading this little blog. You Folks have been Terrific!!

In closing, let’s say that you are working on a project where you want a list of weekdays, but you don’t want to manually enter them in your column or row. The solution is, of course, Autofill!

But how do you do this? Well, you may not have noticed that you can also use the Autofill tool for Auto-filling Weekdays. Here’s what you do:

1.   Enter the starting day into a cell (Monday, Tuesday, whatever…)
2.   Place you mouse pointer over the lower-right corner of the cell (the small black square is the “handle”) until you see the narrow crosshairs appear
3.   Right-click the handle and drag to select the range you want to fill with weekdays
4.   When you release the mouse button, a dropdown menu will appear
5.   Select Fill Weekdays

That’s It! A filled series of Weekdays! This tip works on nearly any version of Excel, so give it a try some time.

Later, Alligator!  ~Bob