Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
This is with Excel 2000. The other Alt and letter combinations work, with
File menu, Insert menu etc but for some reason when I press Alt E it only causes a rectangle to appear around the word Edit, but doesn't open the drop down menu. Does this suggest Alt E has somehow been associated with another command? How could I check this? Or is there any other explanation? For years I have been subconsciously pressing alt E S V to paste values into cells and it's very disconcerting when this no longer works. Grateful for advice |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hit alt-e to see the Edit option depressed.
Hit alt-e again and edit won't be depressed. You can look at all the toolbars to see if there's another icon depressed or hit enter to see if it opens up a dropdown/menu/dialog.... (I'll bet dollar to doughnuts you've got two icons with the same accelerator key.) ========= If you want to remove the accelerator key from the other(s) items, you can: Tools|Customize Rightclick on the item Remove the & (ampersand) from the Name For instance: &Edit would become Edit simonc wrote: This is with Excel 2000. The other Alt and letter combinations work, with File menu, Insert menu etc but for some reason when I press Alt E it only causes a rectangle to appear around the word Edit, but doesn't open the drop down menu. Does this suggest Alt E has somehow been associated with another command? How could I check this? Or is there any other explanation? For years I have been subconsciously pressing alt E S V to paste values into cells and it's very disconcerting when this no longer works. Grateful for advice -- Dave Peterson |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Ps. You could also close the other toolbar(s) or remove the items that share
the accelerator keys from those toolbars. simonc wrote: This is with Excel 2000. The other Alt and letter combinations work, with File menu, Insert menu etc but for some reason when I press Alt E it only causes a rectangle to appear around the word Edit, but doesn't open the drop down menu. Does this suggest Alt E has somehow been associated with another command? How could I check this? Or is there any other explanation? For years I have been subconsciously pressing alt E S V to paste values into cells and it's very disconcerting when this no longer works. Grateful for advice -- Dave Peterson |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks for your advice. I reset the standard toolbar and now Alt E works
properly. Still not quite sure what was causing the problem, because when I hit return after pressing Alt E it just opened up the normal edit menu, so it didn't go to any other command. "Dave Peterson" wrote: Hit alt-e to see the Edit option depressed. Hit alt-e again and edit won't be depressed. You can look at all the toolbars to see if there's another icon depressed or hit enter to see if it opens up a dropdown/menu/dialog.... (I'll bet dollar to doughnuts you've got two icons with the same accelerator key.) ========= If you want to remove the accelerator key from the other(s) items, you can: Tools|Customize Rightclick on the item Remove the & (ampersand) from the Name For instance: &Edit would become Edit simonc wrote: This is with Excel 2000. The other Alt and letter combinations work, with File menu, Insert menu etc but for some reason when I press Alt E it only causes a rectangle to appear around the word Edit, but doesn't open the drop down menu. Does this suggest Alt E has somehow been associated with another command? How could I check this? Or is there any other explanation? For years I have been subconsciously pressing alt E S V to paste values into cells and it's very disconcerting when this no longer works. Grateful for advice -- Dave Peterson |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
It's probably too late now, but if you had hit the alt-e once more, then enter,
you may have found the second item. simonc wrote: Thanks for your advice. I reset the standard toolbar and now Alt E works properly. Still not quite sure what was causing the problem, because when I hit return after pressing Alt E it just opened up the normal edit menu, so it didn't go to any other command. "Dave Peterson" wrote: Hit alt-e to see the Edit option depressed. Hit alt-e again and edit won't be depressed. You can look at all the toolbars to see if there's another icon depressed or hit enter to see if it opens up a dropdown/menu/dialog.... (I'll bet dollar to doughnuts you've got two icons with the same accelerator key.) ========= If you want to remove the accelerator key from the other(s) items, you can: Tools|Customize Rightclick on the item Remove the & (ampersand) from the Name For instance: &Edit would become Edit simonc wrote: This is with Excel 2000. The other Alt and letter combinations work, with File menu, Insert menu etc but for some reason when I press Alt E it only causes a rectangle to appear around the word Edit, but doesn't open the drop down menu. Does this suggest Alt E has somehow been associated with another command? How could I check this? Or is there any other explanation? For years I have been subconsciously pressing alt E S V to paste values into cells and it's very disconcerting when this no longer works. Grateful for advice -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Menu Option No Longer Valid | Excel Discussion (Misc queries) | |||
I can no longer edit hyperlinks via right-click menu, help please | Excel Discussion (Misc queries) | |||
Alt+E No Longer Opens Edit menu | Excel Discussion (Misc queries) | |||
Cells no longer highlighted in XL2003 edit mode? | Excel Discussion (Misc queries) | |||
Edit Menu | Excel Discussion (Misc queries) |