ExcelBanter - Autofill default: I want Fill Without Formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Autofill default: I want Fill Without Formatting (https://www.excelbanter.com/excel-discussion-misc-queries/125332-autofill-default-i-want-fill-without-formatting.html)

Frustrated by Autofill

Autofill default: I want Fill Without Formatting

In Excel 2003, the default setting for Autofill is "fill with formatting".
Since I usually do not want to fill the formatting, I always need to click
the Autofill Options box (showing "Copy Cells", "Fill Formatting Only", or
"Fill Without Formatting") to select "Fill Without Formatting". Is it
possible to reset the default setting to "Fill Without Formatting"?

All times are GMT +1. The time now is 03:49 PM.