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!

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.

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.

Thank you. This saves me a lot of time. I've been wondering why this was deactivated. Anyhow, i have it again.

LizzMason Open Excel > File > Options.In the Excel Options window, click General and uncheck "Show Quick Analysis options on selection" located under "User Interface options".Click OK.Once done, restart the Excel app and check if the Autofill icon will show up correctly.If it does not show up correctly, go to File > Options > Advanced > Cut, copy, and paste and tick the box beside "Show Paste Options button when content is pasted". This option also affects the Autofill Icon, it should always be enabled.

Fill without formatting (Microsoft 365)

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.
- 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?
  - HansVogelaar
    MVP
    Apr 29, 2021
    mikegannon718
    
    I'm really sorry, no idea.
- 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.
- 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
    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?
Tea_Tea
Copper Contributor
Apr 30, 2023
LizzMason
Open Excel > File > Options.
In the Excel Options window, click General and uncheck "Show Quick Analysis options on selection" located under "User Interface options".
Click OK.
Once done, restart the Excel app and check if the Autofill icon will show up correctly.
If it does not show up correctly, go to File > Options > Advanced > Cut, copy, and paste and tick the box beside "Show Paste Options button when content is pasted". This option also affects the Autofill Icon, it should always be enabled.
anandpasumpon
Copper Contributor
Oct 05, 2024
In my 365 microsoft office,when a drag a column at the end there is no (fill without formatting) option and there is only three options 1.copy cells 2.fill series (it is not working)3.flash fill,what shall I do for (fill without formatting)
- SergeiBaklan
  MVP
  Oct 05, 2024
  anandpasumpon
  
  On which platform you are (Windows, Web, Mac, etc) ? In general it looks like
  
  Drag with right button
  
  Drag with left button

Forum Discussion

Fill without formatting (Microsoft 365)

Share

Resources