AutoFill Options AutoFill Options What Else Do You See? Look by the AutoFill handle in Cell A20. There is a little option box that you can click. The AutoFill Options are: Copy Cells Fill Series Fill Formatting Fill Without Formatting Fill Days Fill Weekdays Fill Months Fill Years.   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.   Memo to Self: The example on this page is formatted with the Medium Date format and shows only the Weekdays.