Share via

Autofill button changed

Anonymous
2021-03-09T00:56:28+00:00

My autofill button used to give me the following options:

  • copy cells
  • fill series
  • fill formatting only
  • fill without formatting

and now I get a completely different set of options.

It asks about formatting, charts, totals, tables, sparklines. 

How do I get it back to what it used to be?? 

The button itself looks different too. 

I don't know what I did?? Help!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-03-09T01:33:48+00:00

    Hi Jocelyn,

    Thank you for reaching out. I'm Adie, an Independent Advisor and a Microsoft user like you. I'll be happy to help you out.

    Please follow these steps and see if it will help fix the issue.

    1. In Excel, go to File > Options > Advanced.
    2. Under Cut, copy and paste, make sure that “Show Paste Options button when content is pasted” is checked.

    I hope this helps. Please let me know if you need further assistance.

    Best regards,

    Adie

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2021-03-09T22:37:33+00:00

    Great! I'm glad that helped.

    Have a great day and stay safe!

    Kind regards,

    Adie

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2021-03-09T15:41:43+00:00

    Thank you so much!!! That was it!

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments