how to protect appointed rows or columns to use the mouse and keyboard

J

John Wilson

hzh,

You could include some text in your post.
Maybe then we could figure out what you mean by "appointed"??
"To use the mouse and keyboard" makes absolutely no sense whatsoever.

Maybe you're a new poster???

If so, take a look here before reposting:
http://www.cpearson.com/excel/newposte.htm

Most anything that could be asked in the newsgroups has already been
answered.
Take a look here and you may just find what you're looking for (whatever
that is)??
http://tinyurl.com/29pby

John
 
G

gmangad

If you mean to proect some cells from entering data, you can do the
following.

remove the protection from the cells you want to ALLOW entering.
(Format - cells - protection - then uncheck the 'LOCKED'). Then protect
the sheet (Tools-protection-protect sheet).

By default all the cells are locked and when you protect the sheet, you
are not allowed to enter data. So you need to unlock the cells which
you need to allow the user to enter before protecting sheet.

regards
gt
 
Top