Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I protect a sheet so the rows/columns can't be deleted?
I'm setting up a workbook for continual shared use. Several of the other
users, rather than just deleting the data, highlight the row in question and delete the row. That's throwing off all of the formulas on the final sheet. Is there a way to set protection that will allow the users to edit their data as they need to, but maintain the format and design of each of the sheets, disallowing them from removing any rows? Thanks ~Dani |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I protect a sheet so the rows/columns can't be deleted?
Select all the cells in question, (either specifically, or entire sheet). Go
to format cell, on protection tab, UN-check the locked field. Now, protect the workbook. Users should be able to input/delete data as desired, but can not change formatting of sheet. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Dani" wrote: I'm setting up a workbook for continual shared use. Several of the other users, rather than just deleting the data, highlight the row in question and delete the row. That's throwing off all of the formulas on the final sheet. Is there a way to set protection that will allow the users to edit their data as they need to, but maintain the format and design of each of the sheets, disallowing them from removing any rows? Thanks ~Dani |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect a sheet but allow columns to unhide | Excel Discussion (Misc queries) | |||
Protect Hidden Columns and Rows | Excel Discussion (Misc queries) | |||
Can I protect columns w/in a "List" using Protect Sheet? | Excel Discussion (Misc queries) | |||
Protect sheet and allow grouping of columns | Excel Worksheet Functions | |||
How can I protect certain columns on a sheet so that formulas are. | Excel Discussion (Misc queries) |