ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel Auto Fill Options (https://www.excelbanter.com/excel-discussion-misc-queries/215147-excel-auto-fill-options.html)

astanfo

Excel Auto Fill Options
 
Is there a way to change the default on the Excel auto fill? When you grab
the bottom right of the cell and drag it down it defaults to fill the
formula. I want to change it so it defaults to fill "copy cells" instead of
the formula.
Someone please help!
Thanks

Dave Peterson

Excel Auto Fill Options
 
You can't change the default.

I like to rightclick on that autofill button and then when I let go, I can
choose how I want to fill.



astanfo wrote:

Is there a way to change the default on the Excel auto fill? When you grab
the bottom right of the cell and drag it down it defaults to fill the
formula. I want to change it so it defaults to fill "copy cells" instead of
the formula.
Someone please help!
Thanks


--

Dave Peterson


All times are GMT +1. The time now is 02:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com