Ways How to Switch to Editing Mode in Excel

2 min

100 points

When opening Excel spreadsheets from unknown sources, a feature in Excel called Protected View shields you from potential risks. This is great, but to work on the document, you will need to switch to editing mode.

How to Switch to Editing Mode

Protected View is switched on by default. So whenever you open a file that originated from a website or that you received via email, you are taken to Protected View.

The message bar will appear along the top of the document and offer you the chance to enable editing. Click the “Enable Editing” button.

Protected View with Enable Editing button

The document is now opened as read-only with some content disabled.

Read Only view

Save the document to another location to be able to work on it effectively.

Why Use the Protected View?

Protected View protects you from malware, viruses, and threats that you can be exposed to when opening Excel files from unknown sources. These sources include a website, email attachments, and other unsafe locations such as shared drives.

If you are just viewing the spreadsheet, you will not need editing mode and can happily work with the document while in Protected View.

Can I Disable Protected View?

Yes, but you should check with your IT team or network administrator before doing this as it does expose you to outside threats.

To disable protected view, Click “File” from the taskbar and then select “Options.” Next, choose the “Trust Center” category and then click the “Trust Center Settings” button.

Trust Center window

Select the “Protected View” category.

Excel Protected View settings

There are three settings here that you could disable: files originating from the Internet, unsafe locations, or Outlook attachments. You can disable all three if you do not want Protected View to intervene at all in the future.

Protected View is a useful feature to help protect users from potential threats when opening documents from unknown sources. This is very common when working with Excel on mobile devices and accessing documents when in public locations.

However, most of the time, these spreadsheets are safe. Fortunately, Microsoft makes it relatively easy to switch into Editing Mode.

Like it? Share with your friends!

100 points

What's Your Reaction?

hate hate
confused confused
fail fail
fun fun
geeky geeky
love love
lol lol
omg omg
win win
Sande Kennedy

Sande Kennedy is the founder of SandeKennedy.com & Kenyans247.com He is a Kenyan-based Internetprenuer,blogger Political Activist,informer who has an interest in politics, governance, corporate-fraud and human-interest. Kindly drop me a note if you feel aggrieved on any matter that you would want to be highlighted. Twitter @itssandekennedy , Instagram @itssandekennedy WhatsApp: +254791890826 Read More about me here
Would you like to get published on this Popular Blog? You can now email Sande Kennedy any breaking news, Exposes, story ideas, human interest articles or interesting videos on: info@sandekennedy.com. Videos and pictures can be sent to +254 791890826 here on WhatsApp by clicking this send button
Powered by
Choose A Format
Formatted Text with Embeds and Visuals
Voting to make decisions or determine opinions
Ranked List
Upvote or downvote to decide the best list item
Personality quiz
Series of questions that intends to reveal something about the personality
Trivia quiz
Series of questions with right and wrong answers that intends to check knowledge
The Classic Internet Listicles
The Classic Internet Countdowns
Open List
Submit your own item and vote up for the best submission
Photo or GIF
Upload your own images to make custom memes
Youtube, Vimeo or Vine Embeds
Soundcloud or Mixcloud Embeds
GIF format

Send this to a friend