Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FREEZING several cells of data?
I have a few collums of data, numbers, I want to be protected or
frozen. I want then to not be able to be edited unless I give permission. How do I do this? USING Office 97 thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FREEZING several cells of data?
Click on the small grey square at the joint or the Column Letters and Row
numbers to select all cells then select: Format Cells Protection and uncheck *locked* Next select the cells that you want to protect, ( hlod the Ctrl key pressed if they are not cntiguous), and select as above but this time check the *Locked* again. This will lock only the cells that you want protected. Finally to make the locking active protect the sheet by selecting: Tools Protection Protect Sheet. Leave the three options selected, (there are more in later versions), and enter a pasword then click OK. Re-emter the password in the confirmation dialog box, (Don't forget the password!) Sheet protection is not very strong. It will keep the average used put but anyone who knows a bit about Xl will be able to break it quite simply. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Crackles McFarly" wrote in message ... I have a few collums of data, numbers, I want to be protected or frozen. I want then to not be able to be edited unless I give permission. How do I do this? USING Office 97 thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
freezing a cell or cells | Excel Worksheet Functions | |||
Freezing cells | Excel Worksheet Functions | |||
Freezing cells | Excel Discussion (Misc queries) | |||
Freezing cells | Excel Discussion (Misc queries) | |||
Freezing cells... | Excel Discussion (Misc queries) |