When you are typing data that is in a series, such as days of the week or months of the year, you can use this tool to complete the series. A. Select handle B. Drag and drop C. Custom fill D. Fill handle
Days of the week including weekends Fill Weekdays – you can autofill working days of the week excluding weekends. This is very cool. I can autofill dates excluding the weekends. Fill Months – and you can use the full word or a standard abbreviation for the month, and Excel will autofill the sequence.
