Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Allow Delete cells but not rows
Dear experts,
How can I set in spreadsheet so that I can allow delete of cell contents from A1 to BZ65543 ? But even delete one rows are not allowed in that tab due to some functions (formula) in cells CA1 to CQ2 ? Thanks Elton |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Allow Delete cells but not rows
Tools--Protection--ProtectSheet--
You can specify what to allow and what to be restricted... If this post helps click Yes --------------- Jacob Skaria "Elton Law" wrote: Dear experts, How can I set in spreadsheet so that I can allow delete of cell contents from A1 to BZ65543 ? But even delete one rows are not allowed in that tab due to some functions (formula) in cells CA1 to CQ2 ? Thanks Elton |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I delete rows where cells are empty | Excel Discussion (Misc queries) | |||
delete rows with empty cells throughout the data | Excel Worksheet Functions | |||
delete rows with empty cells | Excel Discussion (Misc queries) | |||
Delete rows with empty cells in columns B&C | Excel Discussion (Misc queries) | |||
Delete Rows where cells does not meet criteria | Excel Worksheet Functions |