By default the slash (/) key acts as a shortcut to the Excel menu bar. Here’s how to disable this so that you may use the slash character within your Microsoft Excel 2016 spreadsheet.
To enable Excel the ability to use the slash in your spreadsheet, follow these steps.
- Select “File” > “Options“.
- Choose “Advanced“, and then scroll down until you see the “Lotus compatibility” section.
- In the “Microsoft Office Excel menu key:” field, replace the slash with a character that you do not use frequently such as a tilde (~) or grave accent (`), then select “OK“.
This will make the slash character available to type in an Excel spreadsheet. The new character you set however will no longer be available to type. You can also leave the field blank if you don’t want a Lotus key.
You Might Also Like
Excel 2016: How to Install and Use Macros
Excel 2016: Unhide Rows or Columns- Excel 2016: How to Lock or Unlock Cells
- Copy and Paste Values Without Formulas in Excel…
- Excel 2019 & 2016: Force "Open as Read Only" Prompt
- Enable/Disable Display of Formulas in Cells in Excel
Enable "Send to Mail Recipient" Option in Excel & Word 2019
How to Enable Track Changes Mode in Word 2016
Savaş Erdem Çalışkan says
what about MacOS???? there’s no such path in macOS excel?
Randy says
Found this solution after 45 minutes of searching online. Worked like a charm. Thanks.
Russ says
Lifesaver. Christmas in July !
Jessa says
Thank you very much! This is exactly the answer I needed. I thought my laptop has a virus or malfunctioned. 😊
Mike says
I found it much easier to type it into Word, then copy and paste into Excel.
One of many clunky “features” in an enormously useful program.
Jason says
Awesome! Thanks so much. I thought I was losing it… Couldn’t start entering text in a cell with /. Just left the Lotus key (whatever that is) blank. Appears to do the same thing as alt.
sridhar says
thanks for making our life easier!
Renee says
Thank you! I was beginning to think my keyboard was malfunctioning!
naomi says
thank you. you are awesome!
Rus says
This one had me and all of my tech-savvy friends stumped. Thanks for putting the solution out here.
joshua says
thanks, It seems that in years of using excel i must have never tried to start a box with a / and yet, I managed to find this super useful page really easily to fix it. Much obliged