Fill Down Menu gone..Excel 2010

perianderson

New Member
Joined
May 31, 2010
Messages
25
Hey everyone, I am hoping someone can help me. After searching various threads I can't seem to find an answer. My fill down menu does not pop up once I click and drag down over several cells. I have checked my options, under advanced, and it is checked
MdhW6Nb
.

I can use the right click and fill down and THAT menu pops up, but I will want the regular left click menu to pop up as I am accustomed to using it. I am thinking it's a keyboard shortcut that I may have inadvertently clicked to disable it. Hoping one of the experts here knows how to get it back.

Cheers,
MdhW6Nb.jpg
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
I found the answer, in case anyone else was interested.

Some users find these Smart Tags helpful, while others think that they’re annoying. (Count me in the latter
group.) To turn off these Smart Tags, choose Office ➪ Excel Options and click the Advanced tab. Remove the
check mark from the two options labeled Show Paste Options Buttons and Show Insert Options Buttons.
 
Upvote 0

Forum statistics

Threads
1,214,593
Messages
6,120,434
Members
448,961
Latest member
nzskater

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top