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

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
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,942
Messages
6,122,366
Members
449,080
Latest member
Armadillos

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