| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect selected cells without protecting worksheet
I am working on a spreadsheet that I only want to protect certain cells from
being altered. When I try to used the directions from Microsoft Office Online Help, it appears I must protect the entire worksheet which defeats the purpose of protecting just certain cells. Another individual will input hours per day, however I don't want this person to be able to change the hourly rate of pay. Any suggestions? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Protect selected cells without protecting worksheet
Right Click on the cells you want unprotected
select Protection Click on hte Protection tab de-select Locked. Protect the sheet You will now be able to edit the unprotected cells. "Kim Poole" wrote: I am working on a spreadsheet that I only want to protect certain cells from being altered. When I try to used the directions from Microsoft Office Online Help, it appears I must protect the entire worksheet which defeats the purpose of protecting just certain cells. Another individual will input hours per day, however I don't want this person to be able to change the hourly rate of pay. Any suggestions? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Protect selected cells without protecting worksheet
On Jul 12, 12:42 pm, Sean Timmons
wrote: Right Click on the cells you want unprotected select Protection Click on hte Protection tab de-select Locked. Protect the sheet You will now be able to edit the unprotected cells. "Kim Poole" wrote: I am working on a spreadsheet that I only want to protect certain cells from being altered. When I try to used the directions from Microsoft Office Online Help, it appears I must protect the entire worksheet which defeats the purpose of protecting just certain cells. Another individual will input hours per day, however I don't want this person to be able to change the hourly rate of pay. Any suggestions? In Excel 2003, it is right click Format Cells... Protection Tab |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect / Block selected worksheet area . | Excel Discussion (Misc queries) | |||
| How do I protect selected cells on my worksheet? | Setting up and Configuration of Excel | |||
| How do I protect selected cells on my worksheet? | Setting up and Configuration of Excel | |||
| How To Lock Cells and Columns without Protecting Worksheet | Excel Worksheet Functions | |||
| Protecting specific cells in a worksheet. | Excel Worksheet Functions | |||
Linear Mode
