Forum Discussion
Excel Autofill Options greyed out
I am trying to use Autofill in Excel to fill date (days), but can only get it to fill years. When I get the box shown below (copied from another post), the fill Days, Weekdays, Months, Years options ...
As variant you try to do that on filtered column.
If I enter some dates then filter them to show the most recent, and try to fill down it still only fills the year, and I get even fewer options on the Autofill Options box.