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

1 comment:

  1. The Casino Review - Dr.MCD
    The Casino's 평택 출장안마 welcome bonus is up to $500 + 1,000 free spins on 1st 군포 출장샵 deposit. When you claim 계룡 출장안마 this bonus, you must make 대구광역 출장샵 a deposit of at 남원 출장안마 least $10 to get