View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Clorox
 
Posts: n/a
Default Can just the formatting alone in a spreadsheet be protected?

I built a financial report that's heavily formatted with boxes, colors, etc.
Is there any way to protect the format, yet allow users to edit the data?
Particularly for filling-in data, it's hard for people to remember to use
"Paste Special Formula" or "Values", so often the formatting gets obliterated
when users just drag to enter the data. Thank you.