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...
HansVogelaar Sorry, I suppose I didn't explain that well. Here's a stepwise description:
- Copying a cell that has a formula in it
- Using ctrl+shift to select a range of cells
- Using ctrl+d to copy that formula to the range
After doing this, I used to have the option (via what I'm assuming is the "fill handle") to select the paste option (i.e., keep source, match destination, paste without formatting, etc.). Now I don't.
Maybe I'm using the wrong terms here.
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.