Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking a Column
Hi,
I have a column with a series of Sum functions. I don't wish the totals to be altered, is there anyway that I can lock the column to prevent this. Many thanks, Simon. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking a Column
Do you never ever want the numbers to be altered? You could copy the column
and then 'paste special'...'values' right on top of the existing column. You will then have the actual numbers rather than the forumlas in the column. (Of course if you wanted to retain the formulas you could insert a new column and do the same thing.) "SiH23" wrote: Hi, I have a column with a series of Sum functions. I don't wish the totals to be altered, is there anyway that I can lock the column to prevent this. Many thanks, Simon. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking a Column
Thanks for the reply Tim. Basically I want it so the values in the column
cannot be altered in anyway. This is why I was wondering as to whether it was possible to 'lock' the column in some way. Regards, Simon. "tim m" wrote: Do you never ever want the numbers to be altered? You could copy the column and then 'paste special'...'values' right on top of the existing column. You will then have the actual numbers rather than the forumlas in the column. (Of course if you wanted to retain the formulas you could insert a new column and do the same thing.) "SiH23" wrote: Hi, I have a column with a series of Sum functions. I don't wish the totals to be altered, is there anyway that I can lock the column to prevent this. Many thanks, Simon. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking a Column
Simon,
Try the protection function "in reverse". Select the columns in the entire worksheet EXCEPT the column of formulas. Click on Format, Cells, Protection. Uncheck the Locked option, and OK. Then click on Tools, Protection, Protect Sheet, and OK. This will put protection on just the formula column and the remainder of the spreadsheet can be used. The formulas will still work, just cannot be changed by users. If formulas need to be changed, click on Tools, Protection, Unprotect Sheet. BAE "SiH23" wrote: Thanks for the reply Tim. Basically I want it so the values in the column cannot be altered in anyway. This is why I was wondering as to whether it was possible to 'lock' the column in some way. Regards, Simon. "tim m" wrote: Do you never ever want the numbers to be altered? You could copy the column and then 'paste special'...'values' right on top of the existing column. You will then have the actual numbers rather than the forumlas in the column. (Of course if you wanted to retain the formulas you could insert a new column and do the same thing.) "SiH23" wrote: Hi, I have a column with a series of Sum functions. I don't wish the totals to be altered, is there anyway that I can lock the column to prevent this. Many thanks, Simon. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking a Column
Okay I understand now.
You could hilight the whole sheet and then 'format cells'....'protection'.... and uncheck the locked box. Then hilgiht the areas of the sheet you do not want changed and once again 'format cells'....'protection' but this time click the 'locked' box. Then go to 'tools'...'protection' and protect the sheet. Only the parts of the sheet you highlighted and locked should now be unaccessable. (Make sure you make a backup copy of your file before fiddling with protecting and locking things.) "SiH23" wrote: Thanks for the reply Tim. Basically I want it so the values in the column cannot be altered in anyway. This is why I was wondering as to whether it was possible to 'lock' the column in some way. Regards, Simon. "tim m" wrote: Do you never ever want the numbers to be altered? You could copy the column and then 'paste special'...'values' right on top of the existing column. You will then have the actual numbers rather than the forumlas in the column. (Of course if you wanted to retain the formulas you could insert a new column and do the same thing.) "SiH23" wrote: Hi, I have a column with a series of Sum functions. I don't wish the totals to be altered, is there anyway that I can lock the column to prevent this. Many thanks, Simon. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locking column names | Excel Discussion (Misc queries) | |||
Microsoft Excel-locking a column | Excel Worksheet Functions | |||
Microsoft Excel-locking a column | Excel Worksheet Functions | |||
Locking column entries to an adjacent linked column | Excel Discussion (Misc queries) | |||
Column widths - locking down | Excel Discussion (Misc queries) |