Change Default Auto Fill Option
Currently Double Clicking the bottom right corner of a cell will Auto Fill down to the last populated row in a data sheet. However in doing so it defaults to 'Fill Series' e.g. 1,2,3,4... it would be great to set the default to, say, 'Copy Cells' e.g. 1,1,1,1...
It's very dangerous when working with dat sets to have the Autofill default as "series" rather than "copy". I have found no way to change the default settings on Autofill. Please, Please create a function to change the default setting for Autofill.
If you have a filter on your data set, even as simple as hiding [blank] cells, the auto fill will default to copy
Agreed. I'd love to be able to set "Fill Without Formatting" as the default!