"How To Excel" Mini-Tutorials|
"Helping Average Spreadsheet Users Become Local Spreadsheet Experts"
Quickly Enter The Months Of The Year
Whenever you need to enter the months of the year in your worksheet, don't waste your time typing out all twelve months. Here's a trick I use to get this task done faster.
Note: You can use either the full month name (i.e. January) or an abbreviation (i.e. Jan).
- Type January in the first cell.
- Move the mouse pointer over the bottom right corner of that cell. The pointer will change to a black plus sign (+).
- Hold down your left mouse button and drag down (or left). You will see a small box pop up showing which month you have filled to.
- When you get to December, release the mouse button and all the months will be filled in for you.
Why not print (CTRL+P) this tip and share it with your friends and associates?
Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict". Subscribe at the www.TheExcelAddict.com/Newsletter.htm.
You'll be amazed how much time you'll save just by learning a few of these tips.|
Copyright © 2003 All Rights Reserved by Francis Hayes (The Excel Addict)