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...
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.
Thank you. This saves me a lot of time. I've been wondering why this was deactivated. Anyhow, i have it again.