software

I'm new to excel and have to manage a large spread sheet.
1) How do I make the headers unchangable? That is, they should be read
only.
2) How do I restrict a cell to certain values? That is, I only want
quot;yes',quot;Noquot;, or quot;Don't Knowquot;
I don't want spaces, or any other values entered....?
3) What is a good book for an Excel newby, but computer experienced...

Thank youNooby,

1) You will need to Protect the sheet (Tools:Protection), I believe. Be sure
to unlock those cells that should allow user input. (Format:Cells:Protection)

2) Data Validation, under Data:

3) Not sure about a book, but there are lots of great web pages available if
you perform a search.

HTH

quot;Noobyquot; wrote:

gt; I'm new to excel and have to manage a large spread sheet.
gt; 1) How do I make the headers unchangable? That is, they should be read
gt; only.
gt; 2) How do I restrict a cell to certain values? That is, I only want
gt; quot;yes',quot;Noquot;, or quot;Don't Knowquot;
gt; I don't want spaces, or any other values entered....?
gt; 3) What is a good book for an Excel newby, but computer experienced...
gt;
gt; Thank you
gt;
gt;