Enable cells at Excel

Nuno Silva · Apr 14, 2015

Hi guys

I need a information if we can enable a line in excel.
I want to enable some cells, to nobody edit it.

Thanks

Momentman · Apr 14, 2015

I guess you mean disable. You will need to Lock the cells by right clicking and selecting "format cells" and in the protection tab, you lock the cell

After which you can protect the sheet with a password while allowing/disallowing users access to selecting or editing the cell

Nuno Silva · Apr 14, 2015

disable right

its already locked, but i can edit it[TABLE="width: 965"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: left"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Quotation No
[/TD]
[TD]Project Name[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD]　xxx
[/TD]
[TD]　xxx
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD]　[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD]Annual Usage (Qote)
[/TD]
[TD]Tooling Cost (KRMB)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD]　xxxx
[/TD]
[TD]　xxxx
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD]　[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD]Sales (KRMB) 2014
[/TD]
[TD]Sales (KRMB) 2015[/TD]
[TD]Sales (KRMB) 2016[/TD]
[TD]Sales (KRMB) 2017[/TD]
[TD]Sales (KRMB) 2018[/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD]　xxxx
[/TD]
[TD]　xxxx
[/TD]
[TD]　xxxx
[/TD]
[TD]　xxxx
[/TD]
[TD]　xxxx
[/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD]Sales (KRMB) 2019
[/TD]
[TD]Sales (KRMB) 2020[/TD]
[TD]Sales (KRMB) 2021[/TD]
[TD]Sales (KRMB) 2022[/TD]
[TD][/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD]　xxx
[/TD]
[TD]xxx　
[/TD]
[TD]　xxx
[/TD]
[TD]　xxx
[/TD]
[TD][/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD]Sales (KRMB) Total with tool
[/TD]
[TD]Sales (KRMB) Total without tool[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD]　[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]　[/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD]Ace Investment (Volume)
[/TD]
[TD]Investment Remark (Machine & Foundation)[/TD]
[TD]Win/Lose Why?[/TD]
[TD]　
[/TD]
[TD]


	$C:\Users\shpublic\AppData\Local\Temp\msohtmlclip1\01\clip_image003.gif$
(button)

[/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD]　xxx
[/TD]
[TD]　xxx
[/TD]
[TD]　xxx
[/TD]
[TD][/TD]
[TD][/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD]　[/TD]
[TD]　[/TD]
[TD]　
[/TD]
[TD]　
[/TD]
[TD]　[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 965"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]I would like do disable the green ones

Thanks
[/TD]
[TD="align: left"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD]　[/TD]
[TD]　[/TD]
[TD]　[/TD]
[TD][/TD]
[TD][/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD]　[/TD]
[TD]　[/TD]
[TD]　[/TD]
[TD]　[/TD]
[TD]　[/TD]
[TD]　[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 965"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]　
[/TD]
[TD]　[/TD]
[TD]　[/TD]
[TD="align: left"]

$C:\Users\shpublic\AppData\Local\Temp\msohtmlclip1\01\clip_image002.gif$

[/TD]
[TD]　[/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD]　[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD]　[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD]　[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]　[/TD]
[TD]

[/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]　[/TD]
[TD]　[/TD]
[TD][/TD]
[TD][/TD]
[TD]　[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]　[/TD]
[TD]　[/TD]
[TD]　[/TD]
[TD]　[/TD]
[TD]　[/TD]
[/TR]
</tbody>[/TABLE]

Enable cells at Excel

Nuno Silva

New Member

Momentman

Well-known Member

Nuno Silva

New Member

Similar threads

Share this page

Enable cells at Excel

Nuno Silva

New Member

Momentman

Well-known Member

Nuno Silva

New Member

Similar threads

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock