Setting Autofill Default
Setting Autofill Default
No option to set AutoFill default to the option you want.
Even for numbers or dates you should be able to use "Copy Cells" in stead of "Fill series"
sumeet
shared this idea
This is a good idea, but we don’t think we’ll be able to support this in the near future. As a workaround, you can use the autocorrect widget in the bottom right of the fill range to set the option you want.
51 comments
-
Buzzydude
commented
Hi Admin,
Wait.....did you guys get hacked???
Ahhh so that's why your non-productive response was posted hahahaOk so NOW that the hacker has been caught and dealt with, could the REAL ADMIN TEAM, you know, an actual Admin who works for this Multi-Million Dollar Company called Microsoft please have this very simple problem fixed.
And next time, do us all a favor and please keep all passwords secure to ensure these HACKERS don't post their dumb idea's again lol.
Cheers
-
Charles Ake
commented
Why should there be a workaround? Microsoft products are used by millions of people and I'm sure there are more than "just a few" that would benefit from Copy Cells being the AutoFill default action. Frankly, why not let each user choose what's best for them. Why does Microsoft have to dictate the way we work? When you're working with complex spreadsheets with thousands and thousands of values, small but extra clicks add up over time and a fix will improve efficiency. Further, Office365 Excel will also Fill Series when even part of the first cell is numerical. For example, Fill Series for "Method 1A" becomes "Method 2A" or "24 hr." becomes "25 hr." This can lead to transcription errors if the user doesn't check ALL the contents of each cell, and use the autocorrect widget EVERY SINGLE TIME.
I would hope that the Excel Team at Microsoft is interested in improving their products, in part, with features that improve efficiency of operations and data accuracy for many end uses.
-
Uncle Fester
commented
for Excel 2016: an explanation is expected, "unable" is an insufficient response. The cumulative picayune work-arounds one has to remember about the hidden idiotsyncracies of excel. Suppose Microsoft has never considered the cumulative impact of memory fatigue for such trivial things?
-
Dimon S
commented
This is fixed already in office 365.
Don't know about 2016 - it's quite buggy.
-
Lenny Nimoy
commented
CTRL button is no solution at all even for small drags. You must know the rules and even then they are buggy (inconsistent), for example if there is text in the content it will increment regardless, if it is only numbers, it will copy. Then there are other combinations of content which will do other stuff. Finally All the rules are out of the window if you select multiple cells!
-
Juan Pablo Gallardo
commented
Im wondering why this idea was removed from my posting, I am the one that originally requested this, and then it was deleted and someone else took the idea and posted it, how that works?
-
JOHANNA PREISZNER
commented
Tyler, you are right of course.
I did not think that big.
So I'm back to angry to MS.
Johanna -
Tyler H
commented
@Johanna, this only works if you are dragging down to copy, it doesn't work for the double click on the bottom right corner. That is a good solution if you are only needing to fill 10 rows, but when you have more data then just that its very irritating, and easy to move on and miss.
-
JOHANNA PREISZNER
commented
Hi, fellow upset commenters.
I just complained about this to my son, and there IS a solution. The CTRL button toggles between the "Fill Series" and "Copy Cells" options. Just press it while you try to do autofill. Whatever is the autofill default on your software the CTRL button will switch it to the other.
No idea why the Excel Team did not let everybody know this instead of just sending a rejection note.
Cheers! -
Tonya Woolard
commented
A workaround? Really? It can't be that freaking difficult to program in a default action! I mean, it's already defaulted to series!! Can't you just change that??
-
Lenny Nimoy
commented
How absurd! your workaround is just what we are trying to avoid because EACH person has to be reminded over and over to click the correction EVERY time this feature is used. It renders the feature impractical even with a small probability of forgetting! This one tiny bug has reduced the usability of ms-excel by a huge margin. On many occasions the errors it has introduced has cost us many thousands of dollars!
-
Tom Johnson
commented
You'd think this was a no brainer...I guess not. Miicrosoft can you please fix this?
-
Anonymous
commented
hello, yes I passed one hour seeking for this option I thought it's normal to have it
so I give a big yes to this option -
Anonymous
commented
Yes please, I need this fix!
I have spreadsheets where the default is the wrong way for every column, and I need to change it. -
Anonymous
commented
95% of the time, I want copy (dates, numbers, etc.) in autofill. Looking forward to this fix!
-
Randy
commented
I almost never want a series. If I do, I'll enter the first two values. Almost always I want autofill to copy. It is astounding to me that Excel would default to a series based on only one value. Really bad idea. At the very least, let me change that. PLEASE!!!
-
Chaz Perry
commented
Why is Microsoft not doing anything about this user request? This is a no-brainer, and should be easy to implement. Maybe they are short on developers? Too big to fail/care?
-
Anonymous
commented
Sometimes I want to set the default to copy instead of fill series. Sometimes I want to have the default to be fill series. This should be changeable.
-
Anonymous
commented
Using Excel is one of the most infuriating things of my day. The problem is when Excel "thinks" it knows what is best and automagically does something dumb.
I just want to set the default behavior of fill to copy. And I just want it to effing copy. I don't want to to fill in a series every now and then because it wants to.
This is dangerous behavior.
-
Anne
commented
PLEASE PLEASE can't this be fixed - i also almost never have the need to fill series, i just want to COPY by default - very frustrating.