software

how do i prevent no data entry into a cell? my spreadsheet has some open
areas that i have quot;greyed outquot; cells to indicate no data entry - but how i
block them to prevent any data entry into the cell?

Lock the cells and protect the worksheet

Select the cells that you wish to UNLOCK via Formatgt;Cells...gt;Protection and
un-check locked.

Now go to toolsgt;protectiongt;protect sheet... and supply a password is
desireable. You will now not be able to change the 'locked' cells

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HISquot;keifquot; gt; wrote in message
...
gt; how do i prevent no data entry into a cell? my spreadsheet has some open
gt; areas that i have quot;greyed outquot; cells to indicate no data entry - but how i
gt; block them to prevent any data entry into the cell?
lock the cells you that want to prevent data entry, then protect the sheet.

quot;keifquot; gt; wrote in message
...
gt; how do i prevent no data entry into a cell? my spreadsheet has some open
gt; areas that i have quot;greyed outquot; cells to indicate no data entry - but how i
gt; block them to prevent any data entry into the cell?
There are a couple ways you can do this. Either Protect the Worksheet or use
Data Validation.

To Protect the worksheet, select each of your cells that you DO want data
entered into. Format the cells and choose quot;Unlockquot; from the Protection tab.
Then, select Tools --gt; Protection --gt; Protect Sheet. You may enter a
password or not, depending how secure you want the worksheet to be. Now only
the cells that you unlocked earlier will allow data to be entered.

To use Data Validation, select the cells that you DO NOT want data entered
into. Select Validation from the Data Menu. Under Allow, change quot;Any Valuequot;
to quot;Text Lengthquot; and set to quot;Equal toquot; and 0. Now, any typing will be
prevented in those cells.

HTH,
Elkarquot;keifquot; wrote:

gt; how do i prevent no data entry into a cell? my spreadsheet has some open
gt; areas that i have quot;greyed outquot; cells to indicate no data entry - but how i
gt; block them to prevent any data entry into the cell?