Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
shading and patterns | Excel Worksheet Functions | |||
row locking, instead of file locking? | Excel Discussion (Misc queries) | |||
Patterns tab | Excel Discussion (Misc queries) | |||
locking formula in cells in without locking whole sheet | Excel Discussion (Misc queries) | |||
patterns | Excel Worksheet Functions |