If you find any post useful then, please do share with others. Thanks!

Popular Posts


Email me

Need help and that also free? I like to learn this way, in case of any question or for a small task, please feel free to email me with details and example data, if required.

Monday, September 8, 2014

Lock Specified Area of a Protected Sheet

Lock Specified Area of a Protected Sheet
When we protect a sheet, all cells are locked by default for editing. For making editable all cells and leaving a few locked, we need to first unlock all cells and then lock specified cells before protecting a sheet.
v  If a sheet is already protected then unprotect it. (Review Tab)
v  Select the whole sheet by Selecting All Button or pressing Ctrl A
v  On the Home tab Click the Format Cells launcher, alternate way is through right click or Ctrl 1.    
v  Got to protection tab and clear the locked check box and click ok. This will unlock all the cells on the sheet, once protected.
v  In your worksheet select only those cells that you want to lock.
v  Again open Format Cells Launcher, same we did earlier.
v  On the protection tab, select the Locked check box and click Ok.
v  Got to Review tab and click Protect Sheet.
v  In the Allow users of this worksheet to list, select the components that we want user to be able to change.
v  In the password to unprotect sheet box, type a password for sheet. Please note the password step is optional, if we don’t provide then any user can unprotect by just clicking on unprotect option.

No comments:

Post a Comment