How to remove edit protection from Excel 2016? Can't edit anything in a given worksheet.
cometody 0 Newbie Poster
rproffitt 2,701 https://5calls.org Moderator
Unprotect the sheet then unlock what you need.
https://support.office.com/en-us/article/protect-a-worksheet-3179efdb-1285-4d49-a9c3-f4ca36276de6
cometody commented: The post is mainly for protecting excel sheet +0
15amoer 0 Newbie Poster
Maybe,you will find more ways of removing edit protection from Excel 2016 on Google than you do here.
rproffitt 2,701 https://5calls.org Moderator
@c, the steps to unprotect are in the same menus to protect. I see 15amoer noted where to get a sip from a fire hose of information too.
cometody 0 Newbie Poster
Google didn't do much help for the programs it suggest
rproffitt 2,701 https://5calls.org Moderator
@c. Sometimes folk leave out a key detail Such as "I don't have the password to unprotect the sheet." You didn't write that so I proceed as it's not a lost password issue. Just one where the user has forgotten where the menus are.
15amoer 0 Newbie Poster
@Comeody.If so that (You don't have the password to unprotect the sheet),all you need to do is unlock it for editing anything in a given worksheet.
Now refer to it: https://www.androidphonesoft.com/resources/excel-password-cracker.html
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.