Mar 02 2021 06:47 PM
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:
Any help is greatly appreciated!
Mar 03 2021 04:29 AM
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:
Apr 29 2021 08:44 AM - edited Apr 29 2021 09:02 AM
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?
Apr 29 2021 09:06 AM
I'm really sorry, no idea.
Dec 01 2021 04:28 AM
Apr 30 2023 08:23 AM
Jan 07 2024 01:58 PM
Thanks. Note for this solution to work you also have to have to enable
Advanced->Editing Options->Enable fill handle...
Jan 15 2024 10:15 AM
@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?
Jan 15 2024 12:25 PM
Although Ctrl+D and the fill handle perform similar functions, they are not directly related.
Ctrl+D works even if you have disabled fill handle and cell drag-and-drop.
So I don't really understand your problem.
Jan 15 2024 12:40 PM
@Hans Vogelaar Sorry, I suppose I didn't explain that well. Here's a stepwise description:
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.
Jan 15 2024 01:49 PM
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.
Jan 15 2024 03:02 PM