By default, the reduce (/) vital display screens the faster ways to the commands on the ribbon in Excel. So, what do you do if you intend to enter a slash in a cell? There’s a way to disable this establishing so you can kind a reduce in cells.
To avoid the reduce vital from turning on the bow command faster ways, click the “File” tab.
On the backstage display, click “Options” in the checklist of items left wing.
On the “Excel Options” dialog box, click “Advanced” in the list of items left wing.
In the “Lotus compatibility” section, change the personality in the “Microsoft Excel menu trick” modify box from a lower to a various personality, such as a tllde (~) or a serious accent (‘). Make certain the character you choose is one you won’t be utilizing in the cells.
Click “OKAY” to approve the adjustment and close the “Excel Options” dialog box.
Now you can kind a reduce in any type of cell in your worksheet.
Once more, the personality you went into as the “Microsoft Excel menu secret” is not available to type in the cells.