close

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 gt; Protection gt; Protect
Worksheet

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

No when you do Tools gt; Protection gt; Protect Sheet, the selected cells
will remain open for user input.DHANRAJ Wrote:
gt; I would like to protect a Excel WorkSheet and at the same time allow
gt; only
gt; particular rows or columns for editing or data entry. How this can be
gt; done?--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: www.excelforum.com/member.php...oamp;userid=32763
View this thread: www.excelforum.com/showthread...hreadid=527929Thanks Captain,
It was a useful tip.
dhanraj.r

quot;CaptainQuattroquot; wrote:

gt;
gt; Before turning on Sheet protection with Tools gt; Protection gt; Protect
gt; Worksheet
gt;
gt; Select the cells that you want to allow input to, and select Format gt;
gt; Cells gt; Protection and uncheck quot;Locked.quot;
gt;
gt; No when you do Tools gt; Protection gt; Protect Sheet, the selected cells
gt; will remain open for user input.
gt;
gt;
gt;
gt;
gt;
gt; DHANRAJ Wrote:
gt; gt; I would like to protect a Excel WorkSheet and at the same time allow
gt; gt; only
gt; gt; particular rows or columns for editing or data entry. How this can be
gt; gt; done?
gt;
gt;
gt; --
gt; CaptainQuattro
gt; ------------------------------------------------------------------------
gt; CaptainQuattro's Profile: www.excelforum.com/member.php...oamp;userid=32763
gt; View this thread: www.excelforum.com/showthread...hreadid=527929
gt;
gt;

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()