Fill without formatting (Microsoft 365)

Occasional Visitor

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 looking for is when there is a drop-down menu that allows you to:

 

  • copy cells,
  • fill series,
  • fill formatting only,
  • fill without formatting, and,
  • flash fill. 

 

Any help is greatly appreciated!

 

 

 

 

 

3 Replies

@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:

 

S0169.png

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.

S0170.png

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?

@mikegannon718 

I'm really sorry, no idea.