Forum Discussion
Auto fill and drag and drop columns unchecked - Excel 2016
Hallo, i've got a little problem. When ever i start excel the option described in the title is always unchecked. Everytime i use excel i have to enable this option. Perhaps somebody has a s...
That sounds odd. This setting should be checked by default I think unless your Admin disabled it:
https://getadmx.com/?Category=Office2016&Policy=excel16.Office.Microsoft.Policies.Windows::L_EnableFillHandleAndCellDragAndDrop
If the admin didn't disable it then the only thing I can think of is to try to repair Office:
https://support.office.com/en-us/article/repair-an-office-application-7821d4b6-7c1d-4205-aa0e-a6b40c5bb88b?ocmsassetID=HA010357402&CorrelationId=b0741cc0-b138-4200-bf42-ce689b47241c&ui=en-US&rs=en-US&ad=US