All XLS Padlock Options > Security > Restrictions > Remove “Enable fill handle and cell drag-and-drop” function |
This "Remove “Enable fill handle and cell drag-and-drop” function" option stops end users from using the fill handle and cell drag-and-drop in the protected workbook. It is the same as in the Excel's general options (Review” – “Check accessibility” – “Options accessibility” – “Advanced” – “Enable fill handle and cell drag-and-drop”) but it lets you override the local user's choice.