ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   In Excel why does the / key activate the menu bar? (https://www.excelbanter.com/excel-discussion-misc-queries/110565-excel-why-does-key-activate-menu-bar.html)

Phil McCon

In Excel why does the / key activate the menu bar?
 
A user wants to enter text in a cell beginning with the forward slash
character.
When she does this it simply activates the File menu but does not enter the
/ in the cell.
Cant find this mentioned in keyboard shortcuts or sticky keys or
accessibility.
Does anyone know how to turn this off?


Shubh

In Excel why does the / key activate the menu bar?
 
Under Tool menu go to Option and choose Transition tab and change th settings
for Microsoft Office Excel menu key from "\" to Blank.

"Phil McCon" wrote:

A user wants to enter text in a cell beginning with the forward slash
character.
When she does this it simply activates the File menu but does not enter the
/ in the cell.
Cant find this mentioned in keyboard shortcuts or sticky keys or
accessibility.
Does anyone know how to turn this off?


Shubh

In Excel why does the / key activate the menu bar?
 
Under Tool menu go to Option and choose Transition tab and change th settings
for Microsoft Office Excel menu key from "\" to Blank.

"Phil McCon" wrote:

A user wants to enter text in a cell beginning with the forward slash
character.
When she does this it simply activates the File menu but does not enter the
/ in the cell.
Cant find this mentioned in keyboard shortcuts or sticky keys or
accessibility.
Does anyone know how to turn this off?


Andy Pope

In Excel why does the / key activate the menu bar?
 
Hi,

This setting can be found,
Tools Options Transitions MS Office Excel menu Key

Cheers
Andy

Phil McCon wrote:
A user wants to enter text in a cell beginning with the forward slash
character.
When she does this it simply activates the File menu but does not enter the
/ in the cell.
Cant find this mentioned in keyboard shortcuts or sticky keys or
accessibility.
Does anyone know how to turn this off?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

L. Vasudev Nathan

In Excel why does the / key activate the menu bar?
 
Just to add
The reason for / key activating the File Menu, is because, Microsoft Excel
was developed after Lotus 123 was in market. Lotus 123 Dos version had / as
the key to activate the menu. So to faciliate the users who are migrating
from Lotus 123 to Excel, this option was provided.

regards
L. Vasudev Nathan

"Andy Pope" wrote:

Hi,

This setting can be found,
Tools Options Transitions MS Office Excel menu Key

Cheers
Andy

Phil McCon wrote:
A user wants to enter text in a cell beginning with the forward slash
character.
When she does this it simply activates the File menu but does not enter the
/ in the cell.
Cant find this mentioned in keyboard shortcuts or sticky keys or
accessibility.
Does anyone know how to turn this off?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info



All times are GMT +1. The time now is 10:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com