Thread: Locking columns
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ben M. Schorr, MVP Ben M. Schorr, MVP is offline
external usenet poster
 
Posts: 7
Default Locking 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" wrote in message
...
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?