Y2
All the cells on a sheet are locked by default. Unlock those cells in
which you want to allow editing. Then protect the sheet and choose the
options you wish. HTH Otto
"Y2Kate" wrote in message
...
I am trying to format my worksheet so that additional lines/columns cannot
be
added and cells cannot be merged. This is a sheet that is being
distributed
to other users for them to add relevant information. I need to be able to
lock the formatting but NOT the editting. Is this possilbe?