How to remove edit protection from Excel 2016? Can't edit anything in a given worksheet.
cometody
0
Newbie Poster
Recommended Answers
Jump to PostUnprotect the sheet then unlock what you need.
https://support.office.com/en-us/article/protect-a-worksheet-3179efdb-1285-4d49-a9c3-f4ca36276de6
Jump to Post@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.
All 6 Replies
rproffitt
2,580
"Nothing to see here."
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,580
"Nothing to see here."
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,580
"Nothing to see here."
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.