View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
walrus walrus is offline
external usenet poster
 
Posts: 29
Default HOW DO I LOCK CERTAIN CELLS

try the following;

Cntrl+A
Cntrl+1
In the protection tab uncheck "LOCKED" box
Select your specific cell(s)
Cntrl+1
Check "LOCKED" box the protection tab

Protect your sheet with passwrod..





"Dan A." wrote:

Can somebody tell me how I can lock our certain cells, rows or columns from
others being able to change anything in those cells. I of course want to
password portect to that I can go in with my password and change certain
cells, rows or columns later on. Using Microsoft Excel 2007 on Windows Vista.

Thanks for any help.