Welcome, Guest: Join Kenyans247 Log In!

Stats: 290 Members, 13,228 topics and 65 posts Date:  Sunday 25 October 2020 at 08:00 AM
Popular & Trending NewestFeatured Links ClassifiedDirectoryLivescoresLive Kenyan TVLive Kenyan Radio Follow Us Like Us

About Us Terms & Conditions Privacy Policy FAQ's Disclaimer Copyright Contact Us Advertise With Us Download K247 APP Marketplace Moderator Policy We Are Hiring Kenya Radio and TV Stations Listen and Watch Live Letter From the C.E.O Kenya Radio Stations Live Kenya TV Stations Live Kenya - Newspapers and News Sites and popular blog Forum Rules

How to Switch to Editing Mode in Excel

Kenyans247 / Science/Technology / Computers / How to Switch to Editing Mode in Excel

117 people viewed

How To Obtain A Pet Passport (import Export Or Transport Pet) In Kenya How To Develop A Business Model For Your Company How To Get Your Business Website Noticed On Google (and Elsewhere) For Free How To Unlock Read-only Powerpoint Presentations
(Go Down) (» Reply topic)
How to Switch to Editing Mode in Excel by Kenyans247(1): Thu Aug 2019 08:22pm
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.
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.

0 Shares 0 Like •

(» Go Up)

You must Sign in or Sign Up to post content

For you to post content on this website you have to log in or register, it only take few minute to create account

Go Up

Recommended for you

How To Prevent Cooking Gas Explosions In Nigerian Homes How To Obtain A Land Rent Clearance Certificate In Kenya How To Register For Eduafya Health Services In Kenya How To Read Ulysses

Currently: 1 guest(s) reading this article

Sections: Kenyans247 ads, Travel, Career, Culture, Environment, Universities, Technology Market, Webmasters, Building/Architecture, Programing, Emojipedia, Lifestyle, Gossip, Forum Games, Theatre/Comedy, Tanzania Forum, Rwanda Forum, South Sudan Forum, Ugandan Forum, Burundi Forum,

About Us | Terms & Conditions | Privacy Policy | FAQ's | Disclaimer | Copyright | Contact Us | Advertise With Us | Download K247 APP | Marketplace | Moderator Policy | We Are Hiring | Kenya Radio and TV Stations Listen and Watch Live | Letter From the C.E.O | Kenya Radio Stations Live | Kenya TV Stations Live | Kenya - Newspapers and News Sites and popular blog | Forum Rules | Featured LinksFollow Us on TwitterLike Us on Facebook

Kenyans247 - Copyright © 2019 - 2020 Sande Kennedy. All rights reserved. See How To Advertise.
Disclaimer: Every Kenyans247 member is solely responsible for anything that he/she posts or uploads on Kenyans247.