View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DBM DBM is offline
external usenet poster
 
Posts: 1
Default Format Spreadsheet

How can I lock the rows and columns in a spreadsheet but allow the user
to change the data in the cells.
Also, in this same spreadsheet I have multiple formulas on multiple
rows, I have found if I add a row the row number is changed and
therefore changes the outcome of the formula. If I add a row how can I
prevent it from effecting the formulas already in place.
Thanks