A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Open Excel.
Go to File - Options.
Click Advanced on the left.
On the right, in the Editing Options section, enable this setting 'Enable fill handle and cell drag and drop'
Then click OK to apply the setting.