How To Remove Enable Editing Button in Excel

Published on January 5, 2017

Hellooooo!! So finally my blog is taking off and today I am publishing my first post! No wonder I am so very excited. I do not want to make this post too long and so I would not be discussing about myself or MadAboutExcel here. Instead, I would request you to visit the About page of MadAboutExcel. There you will find all that you would need to know about me or this blog. So please make sure you check that out. So let the fun begin…

 

In this first blog post, I would like to give a solution to a problem faced by many users of MS Excel – the problem that all downloaded excel documents open in Protected View i.e. you cannot edit the document unless you click on the annoying ‘Enable Editing’ button displayed just under the Main Menu.

If you always need to click the Enable Editing button to be able to edit an excel document you will agree that it is a pain! So let me help you get rid of this frustration once and for all.

Excel documents downloaded from the Internet including emails and from other potentially unsafe locations may contain viruses or other kinds of malware that can harm your computer. To help protect your computer, excel documents originating from these potentially unsafe locations are opened in Protected View.

 

 

By using Protected View, you can read a file and see its contents but you cannot edit them. While it’s easy enough to click the Enable Editing button at the top of the screen when you want to make changes, it can be really annoying to do that every single time you open an excel document.

Here is how you can remove ‘Enable Editing’ button:

1. Click the File Tab.

2. Select ‘Options’

 

3. Select ‘Trust Center’ from the dialogue box

4. Click on ‘Trust Center Settings’ button

5. Select ‘Protected View’

6. Uncheck all three options

7. Click Ok

Now if you open any excel document, it will open in Edit mode and will not show the Enable Editing button.

Now all these steps will work only if your system administrator will allow it. You may find that in the system provided to you by your company all the described options are disabled, but when you open excel you still get the Enable Editing button. This is because in an office environment the macro settings may be disabled for security reasons, and so you may have no choice but to manually accept editing and the enable editing options every time.

Please try the above steps and post a comment to tell me if this post helped you to get rid of the annoying ‘Enable Editing’ button.

I would be publishing some really cool excel tutorials in the days to come that can surely help you get a lot better in Excel. To get updates on all such content please make sure you subscribe to the MadAboutExcel newsletter using the opt-in form that you can see right below this post.

Hope you have enjoyed today’s lesson. Have a great day, keep calm and excel in life. Thank You!

GET MY EXCEL GUIDE FOR FREE
COMPLETE EXCEL FUNCTIONS AND SHORTCUTS GUIDE

Subscribe to our newsletter and get my Complete Excel Functions and Shortcuts Guide for FREE!

Thank you for subscribing.

Something went wrong.

    1. Kushal January 5, 2017
      • VIKRAM NARSARIA January 7, 2017
HUGE LIMITED TIME DISCOUNT ON THE BEST ADVANCED EXCEL COURSE ENROLL NOW!!
EXCEL PRINT TIPS
9 Excel Print Settings You Probably Don’t Know About
excel_look_professional
Making Excel Worksheets Look Professional – A Case Study
14 Excel tips
14 Excel Tips – Make Yourself Super-Efficient in Excel
DATA CLEANING EXCEL
Ultimate Guide to Data Cleaning in Excel – 11 Super-Powerful Data Cleaning Techniques
FREEZE PANES
Freeze Panes in Excel – The Complete Guide
HOW TO LEARN EXCEL
How to Learn Excel and Be a Spreadsheet Champion
BEST BOOKS COURSES EXCEL VBA
Best Books and Courses to Learn Excel VBA
BECOME AN EXCEL NINJA COMPLETE REVIEW
Become An Excel Ninja – Course Review
BEST EXCEL COURSES
10 Best Online Courses to Make You an Excel Wizard
BEST BOOKS COURSES EXCEL VBA
Best Books and Courses to Learn Excel VBA
How to Sort Excel Worksheet in Alphabetical Order
How to Sort Excel Worksheets in Alphabetical Order
VBAPOST1
How to Add And Name A New Sheet At The Same Time Using Excel VBA
ROUNDING NUMBERS IN EXCEL
Rounding Numbers in Excel – The Complete Guide
number_of_words
How to Find the Number of Words in a Text String in Excel
HOW TO FIND IF A TEXT STRING CONTAINS SPECIFIC TEXT IN EXCEL
How to Find if a Text String Contains Specific Text in Excel
How To Indentify ULP case in a text string
How To Identify If A Text String Is In Upper, Lower Or Proper Case
Pivot Tables
How to Insert a Pivot Table in Excel – Pivot Table Basics
How To Convert Pivot Table Into Frequency Distribution
How to Convert Pivot Table into a Frequency Distribution in Excel

GET MY EXCEL GUIDE FOR FREE
COMPLETE EXCEL FUNCTIONS AND SHORTCUTS GUIDE

Subscribe to our newsletter and get my Complete Excel Functions and Shortcuts Guide for FREE!

Thank you for subscribing.

Something went wrong.

Share
Tweet
+1
Pin
Share
Stumble
Enjoyed this video?
How To Disable Protected View And Remove Enable
"No Thanks. Please Close This Box!"