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?
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?
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.
Originally Posted by DHANRAJ
Last edited by CaptainQuattro; 03-30-2006 at 01:31 AM.
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
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks