View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TR Young TR Young is offline
external usenet poster
 
Posts: 21
Default Locking only borders and patterns

Excel 2003 thru and including 2007

Is it possible to lock or protect ONLY the pattern and/or border formatting
in a select range of cells in any of these versions of Excel?

See my attached .pdf for explaination:
If I were to insert a new row for a new part, I want the existing
pattern/border formatting to stay put so that I don't have to redo the
entire sheet's border/pattern formatting. As it is, if I have to add a row
for a new part, the border/pattern will shift down when I insert the new
row.

Thanks in advance.

Edit.... well, for some reason, I can't attach a 400 kb file. Imagine a
ledger sheet with white and green rows to make viewing easier. that is what
I am trying to accomplish, but not have the formatting move when I insert a
row.