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.
|