• Skip to main content
  • Skip to primary sidebar

Technipages

Tutorials and fixes for smartphone, gadget, and computer problems

  • Topics
    • Android
    • Gaming
    • Hardware
    • Internet
    • iOS
    • MacOS
    • Office
    • Software
    • Windows
    • Definitions
  • Product Reviews
  • Downloads
  • About Technipages
Enable Slashes (/) in Excel 2016

Enable Slashes (/) in Excel 2016

By Mitch Bartlett 14 Comments

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.

  1. Select “File” > “Options“.
    Excel 2010 Options selection
  2. Choose “Advanced“, and then scroll down until you see the “Lotus compatibility” section.
  3. 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“.
    Microsoft Excel menu key selection

 

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: How to Install and Use Macros
  • Excel 2016: How to Lock or Unlock Cells
    Excel 2016: How to Lock or Unlock Cells
  • Excel 2016: Unhide Rows or Columns
    Excel 2016: Unhide Rows or Columns
  • Copy and Paste Values Without Formulas in Excel 2019, 2016, & 365
    Copy and Paste Values Without Formulas in Excel 2019, 2016,…
  • How to Enable Track Changes Mode in Word 2016
    How to Enable Track Changes Mode in Word 2016
  • Office 2016 & 2013: How to Enable or Disable DEP Mode
    Office 2016 & 2013: How to Enable or Disable DEP Mode
  • Outlook 2019/2016: Enable/Disable Autocorrect
    Outlook 2019/2016: Enable/Disable Autocorrect
  • Outlook 2016: Enable or Disable Cached Exchange Mode
    Outlook 2016: Enable or Disable Cached Exchange Mode
  • Enable Email Read Receipt in Outlook 2019/2016
    Enable Email Read Receipt in Outlook 2019/2016

Filed Under: Office Tagged With: Excel 2016

Reader Interactions

Comments

  1. Suvadip says

    September 2, 2020 at 2:05 am

    Thanks a lot, very short and excellent answer

  2. jane doe says

    November 15, 2019 at 12:09 pm

    Thank you so much for this, I was pulling my hair out trying to figure out what I accidentally pressed on my keyboard.. How does this even happen? Why is this even a feature in excel for this to happen.

  3. Nicla says

    September 25, 2019 at 8:42 am

    Thank you very much! This is exactly the answer I needed!Thanks a lot! This is exactly the answer I needed! I spent a lot of time finding the solution!

  4. Savaş Erdem Çalışkan says

    August 7, 2019 at 8:26 am

    what about MacOS???? there’s no such path in macOS excel?

  5. Randy says

    June 17, 2019 at 9:40 am

    Found this solution after 45 minutes of searching online. Worked like a charm. Thanks.

  6. Russ says

    August 1, 2018 at 8:07 am

    Lifesaver. Christmas in July !

  7. Jessa says

    June 6, 2018 at 5:25 am

    Thank you very much! This is exactly the answer I needed. I thought my laptop has a virus or malfunctioned. ?

  8. Mike says

    March 31, 2018 at 11:59 pm

    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.

  9. Jason says

    July 10, 2017 at 10:09 pm

    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.

  10. sridhar says

    June 14, 2017 at 10:14 pm

    thanks for making our life easier!

  11. Renee says

    November 19, 2016 at 3:28 pm

    Thank you! I was beginning to think my keyboard was malfunctioning!

  12. naomi says

    September 29, 2016 at 3:42 am

    thank you. you are awesome!

  13. Rus says

    August 18, 2016 at 1:08 pm

    This one had me and all of my tech-savvy friends stumped. Thanks for putting the solution out here.

  14. joshua says

    August 5, 2016 at 3:50 am

    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

Did this help? Let us know!

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Recent Posts

  • Windows 11: How to Add Clocks with Different Time Zones
  • Google Assistant: How to Never Miss a Birthday
  • Windows 11: How to Disable Notifications and Ads
  • How to Use Oculus Quest 2 Air Link
  • How to Create an Avatar in the Oculus Quest 2
  • 5 Free and Fun Math Apps for Kids
  • Windows 11: How to Discover What Graphics Card You’re Using
  • How to Change Display Resolution on Windows 10 and 11

Who’s Behind Technipages?

Baby and Daddy My name is Mitch Bartlett. I've been working in technology for over 20 years in a wide range of tech jobs from Tech Support to Software Testing. I started this site as a technical guide for myself and it has grown into what I hope is a useful reference for all.

© Copyright 2022 Technipages · All Rights Reserved · Privacy