View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
brianTmcnamara
 
Posts: n/a
Default row insertion and formatting default

I'm preparing a model to distribute to various individuals where they will
inevitiably insert new rows. In most cases they will not "insert options"
and insert row with above (or below) formatting. is there a way to set
default formats for inserted rows/columns? Is this possible for cell
formulas? is there also a way to lock row or columns as one can lock a
worksheet?