Forum Discussion

LizzMason's avatar
LizzMason
Copper Contributor
Mar 03, 2021

Fill without formatting (Microsoft 365)

There used to be an option where you could FILL WITHOUT FORMATTING in previous versions of Excel. What happened to that radio button drop-down, and how can I get it back?   This is the option I'm l...
Excel
office 365
HansVogelaar's avatar
HansVogelaar
MVP
Mar 03, 2021

LizzMason 

If you drag the fill handle in the lower right corner of the selection using the right mouse button, a menu should pop up the moment you release the right mouse button.

 

If you drag the fill handle using the left mouse button, an Auto Fill Options button should appear when you release the mouse button:

 

Click this button to see the available options.

If you don't see this button:

  • Select File > Options.
  • Select Advanced in the navigation pane on the left.
  • Scroll down to the section 'Cut, copy, and paste'.
  • Make sure that the check box 'Show Paste Options button when content is pasted' is ticked.
  • Click OK.

 

  • jrobinsonx40sarax2ecom's avatar
    jrobinsonx40sarax2ecom
    Copper Contributor
    Jan 07, 2024

    HansVogelaar 

    Thanks. Note for this solution to work you also have to have to enable

    Advanced->Editing Options->Enable fill handle...  

     

    • scottyoung770's avatar
      scottyoung770
      Copper Contributor
      Jan 15, 2024

      @Hans Vogelaar, jrobinsonx40sarax2ecom Hmm...doesn't seem to work (i.e., fill handle doesn't display) when using Ctrl+D to fill down. Any ideas as to what else might be needed?

      • HansVogelaar's avatar
        HansVogelaar
        MVP
        Jan 15, 2024

        scottyoung770 

        Although Ctrl+D and the fill handle perform similar functions, they are not directly related.

        Ctrl+D works even if you have disabled fill handle and cell drag-and-drop.

        So I don't really understand your problem.

  • 301845Antonio's avatar
    301845Antonio
    Copper Contributor
    Dec 01, 2021
    Thank you. This saves me a lot of time. I've been wondering why this was deactivated. Anyhow, i have it again.
  • mikegannon718's avatar
    mikegannon718
    Copper Contributor
    Apr 29, 2021

    EDIT:  I made a dumb mistake and still had a filter applied.  After disabling the filter, the Paste Options button appeared again.

     

    Hello, I have the same problem, and these steps did not resolve it. There was a new popup called "Quick Analysis" that appeared to replace the Paste Options button. I disabled Quick Analysis, then tried disabling and enabling Paste Options, closing out of Excel and reopening, repeating these steps a few times, and Paste Options still does not show up. Is there anything else that could be blocking Paste Options from appearing?

    • Alfredo's avatar
      Alfredo
      Copper Contributor
      Nov 21, 2024

      Had the same problem. Seems like having a filter and sorting on the file disables this feature. So Select all to show all and the option for copy/fill series should come back.

Resources