ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   when pressing forward slash key numbers appear below headings (https://www.excelbanter.com/excel-discussion-misc-queries/194761-when-pressing-forward-slash-key-numbers-appear-below-headings.html)

Folkcamper

when pressing forward slash key numbers appear below headings
 
I appear to have set the forward slash ket (/) so that it does not appear in
the selected cell but initiates numbers to items on the toolbars.
If I do a sequence of keys with the forward slash in the sequence then it
types OK

John C[_2_]

when pressing forward slash key numbers appear below headings
 
The default for forward slash in excel is a quick access to your menu items.
Check your Tools--Options, Transition tab if you want that to be a different
character. Or you can leave it blank and it will type as normal. Or, if you
are entering text data into a cell that starts with a /, you can enter a
single quote ' first, and then the slash.

Hope this helps.


--
John C


"Folkcamper" wrote:

I appear to have set the forward slash ket (/) so that it does not appear in
the selected cell but initiates numbers to items on the toolbars.
If I do a sequence of keys with the forward slash in the sequence then it
types OK


Dave Peterson

when pressing forward slash key numbers appear below headings
 
You can prefix your entry with an apostrophe: '/whatever goes here

Or you can turn off a Transition setting.

In xl2003 menus:
tools|Options|transition tab|
remove the / character from "Microsoft Office Excel menu key:" box

Folkcamper wrote:

I appear to have set the forward slash ket (/) so that it does not appear in
the selected cell but initiates numbers to items on the toolbars.
If I do a sequence of keys with the forward slash in the sequence then it
types OK


--

Dave Peterson


All times are GMT +1. The time now is 07:14 AM.

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