Keyboard Shortcut Issue

S

Stix_1998

Hello,

I have Office XP on both my home computer and work computer. Within
programs such as Excel or Word, I like to use keyboard shortcuts. On my home
PC, when I hit Alt + D within Excel the 'Data' toolbar drops down. On my
work PC, when I do the same thing the menu item 'Data' is highlighted but
doesn't drop down. The same thing happens with other menus within Office.
My Question is how do I get my work PC to not only highlight the menu but
also have the list drop down like I have on my home PC without an additional
keystoke. Is there a Windows or Microsoft Office setting for this? Any help
would be greatly appreciated. Thanks!
 
T

Tony Jollans

Accelerator keys only invoke the menu if they are unique.

If Alt+D merely highlights the Data menu item it means that there is more
than one item on the menu with "D" set as an accelerator (with D underlined
in the caption) and Data is the first. Someone has customized the menu bar
badly and you need to change the extra item to have a different accelerator
(or none).

Identify the menu item in error - it is to the right of Data and has d
underlined.

Select Tools > Customize

While the dialog is displayed, right click on the offending item identifed
above

In the popup menu there should be an entry labeled "Name" and it will show,
for example, "O&dd Custom Menu Item"

Change it to, perhaps, "Odd C&ustom Menu Item" - I forget all the Excel
menus off the top of my head but choose a letter which doesn't duplicate
anything else - or just remove the ampersand altogether - or completely
change the text - your choice

Press Enter
Close the Customize Dialog
 
Top