Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I LOCK CERTAIN CELLS
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I LOCK CERTAIN CELLS
Select All the active cells in your worksheet. Then click on Home tab
Format Cells Protection and untick Locked OK Now select cells that you wish to lock and repeat above procedure except tick Locked OK Now click Review tab and select Protect Sheet. You can enter a password (you can also place a tick against any other features you might want to carry out e.g. format columns) OK Cells are now locked against modification Hope this helps Incidentally you don't have to shout (caps in heading !!!!) "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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock Cells | Excel Discussion (Misc queries) | |||
Lock Cells | Excel Discussion (Misc queries) | |||
why do some cells not lock? | Excel Discussion (Misc queries) | |||
lock cells | New Users to Excel | |||
how can I lock certain cells? | Excel Discussion (Misc queries) |