Monday, 8 February 2016

Turning off an Excel 2010, 2013, 2016 annoyance!

Here is a great Excel tip, because it addresses one of the most irritating features of Excel 2010, 2013 and 2016 - the "Enable editing" button. For a long time this feature drove me up the wall - I would repeatedly open spreadsheets emailed to me and start typing, only to find that I had to click the "enable editing" button before I could do anything. Then I discovered that this can be turned off, and here's how...
  1. Open Excel and click on the File button, then select Options 
  2. Select Trust Center in the left pane and Trust Center Settings in the right pane
  3. Click on Protected View in the left pane
  4. Choose your options 
NOTE: However irritating it might be, the button is there for a reason, so don't disable it unless you're sure you won't be opening suspicious files. Naturally Sales Ltd accepts no responsibility for the consequences of following this e-tip. I bet that's the best Excel tip you've been given today - why not share it with a friend by clicking one of the "share" buttons below?

You can sign up to get our Excel tips by email at

No comments:

Post a Comment