Excel is a lot of things. Versions XP and 2003 has lots of options in the
protect dialog, where you can allow formatting, filtering and other things
on the locked sheet. Version 2000 and down does not have this.

No version allows formatting of unlocked cells /only/.

HTH. Best wishes Harald

"sanam" skrev i melding
ups.com...
How can I have formatting options like merge cells ,Making Bold etc
active for the unlocked cells of the protected worksheet.Is it possible

in excel?

I locked Few cells of the worksheet and protected it.I want rest all
unlocked cells in the sheet to be allowed to formatted like merging the

unlcoked cells,aligning etc.The moment I protect the sheet the
formatting toolbar gets faded and doesn't allow even the unlocked cells

to be formatted .Is there a way I can allow the unlocked cells of
protected sheet to use the toolbars options??Plz reply if itsnot
possible.....


Regards,
sanam