Forum Discussion
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...
Perhaps you used Ctrl+V. After pasting, you should see an icon near the lower right corner of the paste range that you can click to select paste options; Ctrl will also activate this.
If you don't see this:
Select File > Options > Advanced.
Scroll down to the Cut, Copy and Paste section.
Make sure that the check box 'Show Paste Options button when content is pasted' is ticked.
No, it was ctrl+d (the fill down command) - I actually replicated it before adding my last post. And I also confirmed that the "show paste options" checkbox was checked, the "quick analysis" checkbox was unchecked, etc.
Looks like I may have stumbled across a corner case unfortunately. Thanks for looking into it/trying. Much appreciated.
Looks like I may have stumbled across a corner case unfortunately. Thanks for looking into it/trying. Much appreciated.
