AutoFill Options
What
Else Do You See? Look by the AutoFill handle in Cell A24. There
is a little option box that you can click. The AutoFill Options
are:
Copy Cells
Fill
Series
Fill
Formatting Only
Fill
Without Formatting
Fill Days
Fill
Weekdays
Fill
Months
Fill
Years
Flash Fill
The Day,
Month and Year formatting displays only that portion
of the date that you entered in the Cells. You can choose to Fill
the Cells with or without the Cell Formatting, too.
Fill
Weekdays looks up the dates in your Series and enters only
the days from Monday to Friday. No weekends-sweet.
6. Try This, Now: Fill the Weekdays
Click on the AutoFill Options.
Select: Fill Weekdays.
Keep going...