Dear Sir
In excel if i want to protect a sheet but few areas i dont want to protect so that peoples can do entry there whereas the formulas areas should be protected. Can we do this.
Faisal
Dear Sir
In excel if i want to protect a sheet but few areas i dont want to protect so that peoples can do entry there whereas the formulas areas should be protected. Can we do this.
Faisal
Right click on cell -> Format cells -> Protection -> uncheck Locked box
Then protect sheet and uncheck Select locked cells...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks