View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default 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