Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
hi everybody how can just protect cells not all the sheets?
just I want protect some cells not all the cells of a sheet . best |
#2
![]() |
|||
|
|||
![]()
UnLock the cells you want to remain unprotected.
Select the cells you want to be editable. Then, Format | Cells | Protection. Uncheck Locked. tj "hassan barjini" wrote: hi everybody how can just protect cells not all the sheets? just I want protect some cells not all the cells of a sheet . best |
#3
![]() |
|||
|
|||
![]()
Then you must enable sheet protection.
Gord Dibben Excel MVP On Mon, 6 Dec 2004 06:19:06 -0800, "tjtjjtjt" wrote: UnLock the cells you want to remain unprotected. Select the cells you want to be editable. Then, Format | Cells | Protection. Uncheck Locked. tj "hassan barjini" wrote: hi everybody how can just protect cells not all the sheets? just I want protect some cells not all the cells of a sheet . best |
#4
![]() |
|||
|
|||
![]()
http://www.aspfaq.com/5005
-- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "hassan barjini" wrote in message ... hi everybody how can just protect cells not all the sheets? just I want protect some cells not all the cells of a sheet . best |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Protected cells -automatically format to a different color | Excel Discussion (Misc queries) | |||
protect a cell | Excel Discussion (Misc queries) | |||
Averaging only cells with data | Excel Discussion (Misc queries) | |||
Calculating without including Hidden Cells | Excel Discussion (Misc queries) | |||
Cells losing formatting | Excel Discussion (Misc queries) |