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.