Hello, is there a way to protect individual cells? Thank you!
Hello, is there a way to protect individual cells? Thank you!
Originally Posted by amos79
Go to Tools/Protection/Protect Sheet
Regards.
BenjieLop
Houston, TX
Good afternoon Amos79
But remember that this will protect only cells that have the protection flag set and that new workbooks have all cells set to protected as default. To set the protect flag to false, select all the cells you want UNPROTECTED and then press ctrl + 1, protections and unchecked the "locked" box. Then you can use the Tools > Protection > Protect Sheet.
HTH
DominicB
All cells are protected by default, but not effective until the sheet is
protected. Before protecting the sheet, you want to either turn
off protection for cells you want to change or to turn off protection
for all cells, and then protect the cells you don't want to change
before turning on sheet protection.
Select the cells you want to change , then
Format, cells, protection
The unprotect all cells first before protecting just some
of the cells use Ctrl+A to select all cells,
or in 2003 use Ctrl+Shift+SpaceBar to select all cells
Format, cells, protection
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"BenjieLop" <[email protected]> wrote in message
news:[email protected]...
>
> amos79 Wrote:
> > Hello, is there a way to protect individual cells? Thank you!
>
>
> Go to *Tools/Protection/Protect Sheet*
>
> Regards.
>
>
> --
> BenjieLop
>
>
> ------------------------------------------------------------------------
> BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
> View this thread: http://www.excelforum.com/showthread...hreadid=471120
>
amos79,
By default all cells in excel are protected or locked, select the cells you
want to unlock and go to format, cells, protection and uncheck locked, the
go to tools, protection, and protect sheet, enter a password if you want,
now only the cells that you unlocked can be edited. Be aware that this
protection is very easy to break, the code to do so can be found very easy,
but it will work for most people .
If you only need a few locked I would select them all first, Ctrl A, then
go to format, cells, protection and uncheck locked, then select the cells
you want to lock and go to format cells and check locked, the go to tools,
protection, and protect sheet, enter a password if you want, now the cells
that you locked can not be edited
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"amos79" <[email protected]> wrote in
message news:[email protected]...
>
> Hello, is there a way to protect individual cells? Thank you!
>
>
> --
> amos79
> ------------------------------------------------------------------------
> amos79's Profile:
> http://www.excelforum.com/member.php...o&userid=27591
> View this thread: http://www.excelforum.com/showthread...hreadid=471120
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks