Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Protect work sheet
Hi All
Is there a way to protect a worksheet and still imput new data into the blank cells on that worksheet? Thanks Lee |
#2
|
|||
|
|||
Lee, you can only enter data in unlocked cells in a portected worksheet,
By default all cells in excel are protected or locked, select the cells you want to unlock and go to format, cells, protection and uncheck locked, the go to tools, protection, and protect sheet, enter a password if you want, now only the cells that you unlocked can be edited. If you only need a few locked I would select them all first, Ctrl A, then go to format, cells, protection and uncheck locked, then select the cells you want to lock and go to format cells and check locked, the go to tools, protection, and protect sheet, enter a password if you want, now the cells that you locked can not be edited -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Lee" wrote in message ... Hi All Is there a way to protect a worksheet and still imput new data into the blank cells on that worksheet? Thanks Lee |
#3
|
|||
|
|||
Thanks Paul
Very good instructions---- Lee "Paul B" wrote in message ... Lee, you can only enter data in unlocked cells in a portected worksheet, By default all cells in excel are protected or locked, select the cells you want to unlock and go to format, cells, protection and uncheck locked, the go to tools, protection, and protect sheet, enter a password if you want, now only the cells that you unlocked can be edited. If you only need a few locked I would select them all first, Ctrl A, then go to format, cells, protection and uncheck locked, then select the cells you want to lock and go to format cells and check locked, the go to tools, protection, and protect sheet, enter a password if you want, now the cells that you locked can not be edited -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Lee" wrote in message ... Hi All Is there a way to protect a worksheet and still imput new data into the blank cells on that worksheet? Thanks Lee |
#4
|
|||
|
|||
Supposedly Excel 2002 will let you do this. I'm having the same problem.
Marc "Paul B" wrote in message ... Lee, you can only enter data in unlocked cells in a portected worksheet, By default all cells in excel are protected or locked, select the cells you want to unlock and go to format, cells, protection and uncheck locked, the go to tools, protection, and protect sheet, enter a password if you want, now only the cells that you unlocked can be edited. If you only need a few locked I would select them all first, Ctrl A, then go to format, cells, protection and uncheck locked, then select the cells you want to lock and go to format cells and check locked, the go to tools, protection, and protect sheet, enter a password if you want, now the cells that you locked can not be edited -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Lee" wrote in message ... Hi All Is there a way to protect a worksheet and still imput new data into the blank cells on that worksheet? Thanks Lee |
#5
|
|||
|
|||
your welcome, thanks for the feedback
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Lee" wrote in message ... Thanks Paul Very good instructions---- Lee "Paul B" wrote in message ... Lee, you can only enter data in unlocked cells in a portected worksheet, By default all cells in excel are protected or locked, select the cells you want to unlock and go to format, cells, protection and uncheck locked, the go to tools, protection, and protect sheet, enter a password if you want, now only the cells that you unlocked can be edited. If you only need a few locked I would select them all first, Ctrl A, then go to format, cells, protection and uncheck locked, then select the cells you want to lock and go to format cells and check locked, the go to tools, protection, and protect sheet, enter a password if you want, now the cells that you locked can not be edited -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Lee" wrote in message ... Hi All Is there a way to protect a worksheet and still imput new data into the blank cells on that worksheet? Thanks Lee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel | |||
How do i protect a work sheet in excel 2000 that will still enabl. | Excel Discussion (Misc queries) | |||
How do I protect work sheet against the "Delete" function? | Excel Discussion (Misc queries) | |||
Variable validation-password protect sheet | Excel Worksheet Functions | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |