blocking cells

joseemorales

New Member
Joined
Oct 27, 2002
Messages
29
I have an expression in a cell that i do not want it altered what is the way to block the cell so that the result of the expression shows and no overwriting is allowed for that particular cell.
I am pretty sure this is trivial but i'm in a hurry and this forum has saved me before...
Thanks,
JM
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Visions_Fugitive

New Member
Joined
Apr 15, 2002
Messages
18
You should lock the cell (Format > Cells > Protection [also check 'Hidden' to hide the formula]) and then protect the worksheet (Tools > Protection > Protect Sheet). Locking and hiding won't take effect until you protect the worksheet. Cells are locked by default, so you might first want to select every cell and unlock them, then only lock the cell(s) you really want to lock. Then protect the worksheet.
 

jimmywanna

Board Regular
Joined
Mar 18, 2002
Messages
182
The way i ahve donr thi is:
you need to select the whole page, I done this by holding the left mouse button and dragging across the A, B, C etc ate the top of the sheet until all of the sheet was selected.
Then i right mouse clicked in the sheet and selected "format cells" then the properties tab. make sure it says "unlocked"
Then click in the cell you don't want to be fiddled with, right click, select format cell, properties and click on locked.
Then unselect everything and click on tolls, protection, protect sheet.
The sheet can then be used but the cell which you have protected can't be amended.

This is hoe i have done it anyway, there may be a much simpler solution

jimmy
 

Forum statistics

Threads
1,143,702
Messages
5,720,374
Members
422,280
Latest member
scottylan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top