How to lock certain cells or columns?

**ADB** · 12-11-2009, 02:04 AM

Me again, last one today!

IL have some files to be used by several users, now I don't want them to be able to change some of the rows and cells. So I'm the only one who can change them. How do I do this?

Thanks again,

ADB

**ConneXionLost** · 12-11-2009, 02:08 AM

Hi ADB,

That is available under "Tools > Protection..."

Just search for "Protection" in the Excel Help.

Cheers,

**ADB** · 12-11-2009, 02:19 AM

Hi,

Thanks for replying so quickly. I tried that, but no success. I want others to use my file on a server, but they should not be able to change formulas. Data entry should be possible, but some cells should not be touched. I can't find that in help!

ADB

**ConneXionLost** · 12-11-2009, 02:30 AM

Hi ADB,

Note that under "Format > Cells > Protection" each cell of a worksheet may be locked or have a formula hidden. To use this feature, you must enable "Protect Sheet...". Excel will give you the choice of which actions your users may conduct on a protected sheet. For those cells you do not want protected, you must remove the cell protection in the format dialog box.

Cheers,

**ADB** · 12-11-2009, 06:31 AM

Hi,

I didn't really follow you, but after reading this: http://www.uwgb.edu/compserv/ehelp/excel/protect.htm I understand what you mean. Maybe I need the visual help...

Thanks again!