Feedback by UserVoice

 

How can we improve Excel for Windows (Desktop Application)?

← Excel for Windows (Desktop Application)

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"

99 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

sumeet shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

33 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Anonymous commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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.

  • Yvonne Webb commented  ·   ·  Flag as inappropriate

    I almost NEVER need to fill in with a series. It's nice to have the option but we should have the option to change the default.

  • Anonymous commented  ·   ·  Flag as inappropriate

    I want to set the default auto fill to copy. Period. When I am dealing with spreadsheets with thousands of rows of data, I don't the stupid thing to automagically do "series".

  • Doug commented  ·   ·  Flag as inappropriate

    This would be a great help! I often need to copy a block of four items three are text and one is a date. The text copies fine but the review occurred today, each value for date gets incremented by 1 when I copy down the four cells.

  • Alex commented  ·   ·  Flag as inappropriate

    When will this be dev'd?
    I've been periodically checking on this for years. Even today, I find forums where this has been requested as far back as 2005.
    Please prioritize! :)

  • Orin commented  ·   ·  Flag as inappropriate

    Yes, please add ability to set default for autofill options. i used the double click method rather than dragging the handle quite a bit, so having an option to fill cell with copy rather than series would be very helpful

  • Anonymous commented  ·   ·  Flag as inappropriate

    in my job in banking, everytime I auto-fill it almost always uses the wrong one that I need. would love to switch the defaults around.

← Previous 1

Excel for Windows (Desktop Application): Editing

Categories

Feedback and Knowledge Base

(thinking…)