To allow edit of particular rows and protect other rows from editi
 

I would like to protect a Excel WorkSheet and at the same time allow only
particular rows or columns for editing or data entry. How this can be done?

To allow edit of particular rows and protect other rows from editi
 

Before turning on Sheet protection with Tools Protection Protect
Worksheet

Select the cells that you want to allow input to, and select Format
Cells Protection and uncheck "Locked."

No when you do Tools Protection Protect Sheet, the selected cells
will remain open for user input.





DHANRAJ Wrote:
I would like to protect a Excel WorkSheet and at the same time allow
only
particular rows or columns for editing or data entry. How this can be
done?


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=527929

To allow edit of particular rows and protect other rows from e
 

Thanks Captain,
It was a useful tip.
dhanraj.r

"CaptainQuattro" wrote:


Before turning on Sheet protection with Tools Protection Protect
Worksheet

Select the cells that you want to allow input to, and select Format
Cells Protection and uncheck "Locked."

No when you do Tools Protection Protect Sheet, the selected cells
will remain open for user input.





DHANRAJ Wrote:
I would like to protect a Excel WorkSheet and at the same time allow
only
particular rows or columns for editing or data entry. How this can be
done?


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=527929