MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Sheet Protection

Posted by Dee on January 13, 2002 5:13 PM

If I protect a sheet but leave cells unlocked so users can enter data, is there a way to allow them to center/left align and bold the data? I tried this, but these options have been grayed out.

Posted by Jacob on January 13, 2002 6:51 PM


If the sheet is protected then no, but you could also use data validation or restrict the scroll area to stop them from messing with certain cells and leave the sheet unprotected. Also you can add a toolbar button or hot key to run a macro that will unprotect, center, then reprotect for example.