Home |
Search |
Today's Posts |
#1
|
|||
|
|||
protect a single row of formulas
how do I protect a single row or group of rows (or columns) without
protecting the entire sheet. I have tried everything that I can think of but nothing works. I have a spreadsheet that tracks labor hours. I have several rows and columns I need protected, leaving areas for data entry. |
#2
|
|||
|
|||
Hi
basically, you need to "unlock" the bits you want people to get to (format / cell / protection and untick the locked check box) and then protect the sheet (tools / protection / protect sheet). -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "dalstar" wrote in message ... how do I protect a single row or group of rows (or columns) without protecting the entire sheet. I have tried everything that I can think of but nothing works. I have a spreadsheet that tracks labor hours. I have several rows and columns I need protected, leaving areas for data entry. |
#3
|
|||
|
|||
Thanks for the response. Is there anything else that needs to be done
(refresh or something)? I have tried your suggestion several times and I am still able to go into the cell I wanted protected and overwrite the formula. jm "JulieD" wrote in message ... Hi basically, you need to "unlock" the bits you want people to get to (format / cell / protection and untick the locked check box) and then protect the sheet (tools / protection / protect sheet). -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ...well i'm working on it anyway "dalstar" wrote in message ... how do I protect a single row or group of rows (or columns) without protecting the entire sheet. I have tried everything that I can think of but nothing works. I have a spreadsheet that tracks labor hours. I have several rows and columns I need protected, leaving areas for data entry. |
#4
|
|||
|
|||
Hi
you might need to check that the cell you want to LOCK has the "locked" value ticked in format / cells / protection. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "dalstar" wrote in message ... Thanks for the response. Is there anything else that needs to be done (refresh or something)? I have tried your suggestion several times and I am still able to go into the cell I wanted protected and overwrite the formula. jm "JulieD" wrote in message ... Hi basically, you need to "unlock" the bits you want people to get to (format / cell / protection and untick the locked check box) and then protect the sheet (tools / protection / protect sheet). -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ...well i'm working on it anyway "dalstar" wrote in message ... how do I protect a single row or group of rows (or columns) without protecting the entire sheet. I have tried everything that I can think of but nothing works. I have a spreadsheet that tracks labor hours. I have several rows and columns I need protected, leaving areas for data entry. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I protect certain columns on a sheet so that formulas are. | Excel Discussion (Misc queries) | |||
How do I protect cell formulas used for daily counts? | Excel Worksheet Functions | |||
How to create Multiple Conditional Formulas in a single cell? | Excel Discussion (Misc queries) | |||
Displaying the results of multiple formulas in a single cell. | New Users to Excel | |||
How can I combine IF, COLUMN, and LARGE formulas in a single cell? | Excel Worksheet Functions |