ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   auto fill (https://www.excelbanter.com/excel-discussion-misc-queries/70668-auto-fill.html)

sunshine

auto fill
 
how do you change the auto fill options default

Dave Peterson

auto fill
 
I don't think you can change that behavior. But you can rightclick on the
autofill button and drag. When you let go, you'll see a list of things you can
choose from.

sunshine wrote:

how do you change the auto fill options default


--

Dave Peterson

sunshine

auto fill
 
Thanks, Dave! I realize that ... the problem is the default is set to fill
series and you have to go into the list every time you use copy cells which
is the setting used 95% of the time. I appreciate your response.

"Dave Peterson" wrote:

I don't think you can change that behavior. But you can rightclick on the
autofill button and drag. When you let go, you'll see a list of things you can
choose from.

sunshine wrote:

how do you change the auto fill options default


--

Dave Peterson



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

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