How to allow user to edit text but not change formatting

Asked By 10 points N/A Posted on -

I am looking for help in finding a way to restrict the user of excel to only edit the text in the cells but retain formatting. The user can update his name, correct spelling etc buy should not change background color or font size and font. How to control these? I am using Microsoft 2010 Excel in compatibility mode. If you can share me snapshots of the controls or at least the steps it will be of great help. One more information is that th contents what user enters will get updated automatically in other sheets of same work book which will be password protected. Thank you


Login/Register to Answer

Related Questions