How to Enable Typing Slashes in Cells in Excel

By default, the slash (/) key displays the shortcuts to the commands on the ribbon in Excel. So, what do you do if you want to enter a slash in a cell? There’s a way to disable this setting so you can type a slash in cells.

part 1

To prevent the slash key from activating the ribbon command shortcuts in the excel, click the “File” tab.

part2

On the backstage screen, click “Options” in the list of items on the left part.

part3

On the “Excel Options” dialog box, click “Advanced” in the list of items on the left part.

part4

In the “Lotus compatibility” section, replace the character in the “Microsoft Excel menu key” edit box from a slash to a different character, such as a tllde (~) or a grave accent (`). Make sure the character you choose is one you won’t be using in the cells.

Click “OK” to accept the replace and close the “Excel Options” dialog box.

part 5

Now you can type a slash in any cell in your worksheet.

Again, the character you entered as the “Microsoft Excel menu key” is not available to type in the cells.