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.

 

Exam 77-882: Microsoft Excel 2010 Core

2. Creating Cell Data

2.2. Apply AutoFill: Select from the Options List