Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How To Lock Cells
I was just wondering how can i lock cells so a formula cannot be eddited or how do i lock cells so any of the information cannot be edited as well. Please and thanks -- Ziggy M ------------------------------------------------------------------------ Ziggy M's Profile: http://www.excelforum.com/member.php...o&userid=36338 View this thread: http://www.excelforum.com/showthread...hreadid=573038 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How To Lock Cells
Got It.. Thanks -- Ziggy M ------------------------------------------------------------------------ Ziggy M's Profile: http://www.excelforum.com/member.php...o&userid=36338 View this thread: http://www.excelforum.com/showthread...hreadid=573038 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How To Lock Cells
format|cells|protection tab|check locked
But this works in conjunction with: tools|protection|protect sheet (and this protection is easily broken.) Ziggy M wrote: I was just wondering how can i lock cells so a formula cannot be eddited or how do i lock cells so any of the information cannot be edited as well. Please and thanks -- Ziggy M ------------------------------------------------------------------------ Ziggy M's Profile: http://www.excelforum.com/member.php...o&userid=36338 View this thread: http://www.excelforum.com/showthread...hreadid=573038 -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How To Lock Cells
Just highlight the cell(s) you wish to lock, then right click on those cells and go to Format Cells. From there, go to the "Protection" tab. You can choose how you want to protect the cell. Once you have finished that, you must then protect the entire sheet - go to Tools Protection Protect Sheet. That should do it =) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i remove shift lock (highlighting cells) from excel? | Excel Discussion (Misc queries) | |||
Lock all cells? | Excel Discussion (Misc queries) | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Can I use the grouping and lock and protect cells | Excel Discussion (Misc queries) | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |