Home > Computing > Slash key in Excel

Slash key in Excel


It took me a while to find this so I decided to make an entry here in case anyone else runs across this problem.  I’m working on a spreadsheet for IP address management and have have a column for the CIDR.  /26 for example.  The problem is that as soon as you hit the / key  a bunch of letters pop up over the ribbon.  The same thing happens when you hit the Alt key.  To stop this click File | Options | Advanced and scroll all the way down to Lotus Compatibility and you’ll see Microsoft Excel menu key.  Remove the / in that box and click OK.  Now you can type a / in a cell without the keyboard menu popping up.

Advertisements
Categories: Computing Tags: , , ,
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: