Automatically list the days of the week or months of the year
Auto fill is one of the most useful features in Microsoft Excel. For some reason it also happens to be somewhat unknown. Using this feature you can easily list the days of the week, months of the year, quarters, time, and even names from a list. Since there are so many uses I will cover two today and save the others for a future blog.
List the days of the week
1. Type the first day into a cell. It does not matter if you type Monday or Mon, just know that your pattern will be followed.
2. Rest on the cell’s fill handle. This is the small black box in the lower right hand corner of the cell.
3. Your cursor should become a black cross.
4. Hold down your mouse button and drag down a column to list the days in the column, or drag it across the row to list the days in your row.
This is the same process for listing months of the year.
List the days in the workweek
For our second tip – Let’s suppose you want to list only the dates for days in the “workweek”. (Haha. My workweek seems to be every day). The steps would differ slightly:
- Type the starting date into the cell and press enter
- Click in the cell
- Look on the HOME ribbon in the EDITING group for the FILL icon
- Click the down arrow
- Choose SERIES
- To list the dates in a column choose COLUMN
- Chose DATE from the TYPE area
- Choose WEEKDAY from the DATE UNIT area
- Type in the last date that you want to see in the VALUESTOP
- Click OK
That is all there is to it. Congratulations!