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 are all greyed out, so not available. How do a correct this issue? Thanks.
2 Replies
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.
