1
Hello I would like to know if there is an option in Excel, which to block certain columns so that only columns are available that are always edited...
Example: I have this column selected, and I want to block it, so that every time you make a change, don’t edit it by accident or something like that.
1
Shift+Ctrl Select the desired column and cells, right-click-> Format cells-> Go to the Protection -> tab and from a checked check check check the selection in Locked and from an ok.
Then go to the top tab of the Excel menu click on Review protect sheet and from an ok.
1
Hello, yes. There may be variations according to your Excel version or different procedures. It’s usually like this, but it might be something different. This is the basic for sheet protection, so you can change the permissions, and see what best fits your need.
Select cells and lock cells.
After locking cells, protect the spreadsheet.
Enter a password (optional) and select what you want to block in the spreadsheet.
If you have entered a password, just repeat the password and click "OK"
Save your password somewhere, because if you need to modify any cell you will need to unlock the spreadsheet.
If you try to edit a protected cell, this pop-up will appear.
Browser other questions tagged excel
You are not signed in. Login or sign up in order to post.