Hi,
I have columns in my spreadsheet that have formulas, and as many people will
be entering information into the spreadsheet, i want to lock the columns with
formulas. Is there a way to lock only certain columns?

Select the column, right-click, Format Cells, Protection, Lock the cells.
Then you also have to turn on Protect Sheet. The exact steps vary slightly
by version of Excel, but you can probably figure it out.

--
-Ben-
Ben M. Schorr, MVP
Roland Schorr & Tower
http://www.rolandschorr.com
http://www.officeforlawyers.com/outlook.html
Author: The Lawyer's Guide to Microsoft Outlook 2007:
http://tinyurl.com/ol4law-amazon

"Shannan" <(E-Mail Removed)> wrote in message
newsFA5EDD4-CDCA-4BDC-B524-(E-Mail Removed)...
> Hi,
> I have columns in my spreadsheet that have formulas, and as many people
> will
> be entering information into the spreadsheet, i want to lock the columns
> with
> formulas. Is there a way to lock only certain columns?

Hi,
select the whole sheet, right click in the mouse, format cells, protection,
uncheck lock, then select the two columns you want to protect and check the
Lock box, then protect your sheet

"Shannan" wrote:

> Hi,
> I have columns in my spreadsheet that have formulas, and as many people will
> be entering information into the spreadsheet, i want to lock the columns with
> formulas. Is there a way to lock only certain columns?

You actually lock the Cells in the columns.

Shannan wrote:
> Hi,
> I have columns in my spreadsheet that have formulas, and as many people will
> be entering information into the spreadsheet, i want to lock the columns with
> formulas. Is there a way to lock only certain columns?