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

[DHANRAJ]

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]

Before turning on Sheet protection with Tools > Protection > Protect sheet

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

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

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?

[DHANRAJ]

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
>
>