Forum Discussion
Fill without formatting (Microsoft 365)
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.
Thanks. Note for this solution to work you also have to have to enable
Advanced->Editing Options->Enable fill handle...
@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?
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.
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.
