ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   / key (https://www.excelbanter.com/excel-discussion-misc-queries/253885-key.html)

kjdaniel46

/ key
 
I have done something and I don't know how to undo it. I was working on a
spreadsheet and was trying to input / but it just causes numbers and letters
to appear at the top of the toolbar over the icons and when I hit the number
or letter it tells me what that icon does. If I use another letter in the
cell and then the / it types it in. It does this even after I close excel
and start over. What have I done and how can I undo it?
--
kjd

Ms-Exl-Learner

/ key
 
I hope that you are using excel 2007.

Click the Office Ribbon Button (colorful round circle at the top Left
corner)Excel OptionsAdvanced Lotus CompatibilityMicrosoft Office Excel
Menu Key:Delete the / OR give some other keyboard button and give ok.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"kjdaniel46" wrote:

I have done something and I don't know how to undo it. I was working on a
spreadsheet and was trying to input / but it just causes numbers and letters
to appear at the top of the toolbar over the icons and when I hit the number
or letter it tells me what that icon does. If I use another letter in the
cell and then the / it types it in. It does this even after I close excel
and start over. What have I done and how can I undo it?
--
kjd


Dave Peterson

/ key
 
You can start your data entry with an apostrophe: '/

Or you can toggle a setting:
(in xl2003 menus)

Tools|Options|Transition tab
remove the / from the "Microsoft Office Excel Menu Key" box.



kjdaniel46 wrote:

I have done something and I don't know how to undo it. I was working on a
spreadsheet and was trying to input / but it just causes numbers and letters
to appear at the top of the toolbar over the icons and when I hit the number
or letter it tells me what that icon does. If I use another letter in the
cell and then the / it types it in. It does this even after I close excel
and start over. What have I done and how can I undo it?
--
kjd


--

Dave Peterson

Gord Dibben

/ key
 
ButtonExcel OptionsAdvanced.

Scroll down to Lotus Compatibility and remove the "/" from the Microsoft
Office Excel menu key.


Gord Dibben MS Excel MVP

On Wed, 20 Jan 2010 08:42:09 -0800, kjdaniel46
wrote:

I have done something and I don't know how to undo it. I was working on a
spreadsheet and was trying to input / but it just causes numbers and letters
to appear at the top of the toolbar over the icons and when I hit the number
or letter it tells me what that icon does. If I use another letter in the
cell and then the / it types it in. It does this even after I close excel
and start over. What have I done and how can I undo it?




All times are GMT +1. The time now is 09:50 PM.

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