View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
pollyanna
 
Posts: n/a
Default Preventing formulas being pasted over while editing

I am a semi experienced excel user however I find when entering data for
monthly reports, I seem to be deleting formulas when editing data and
therefore my spreadsheets don't calculate correctly. I have heard there is a
button that I can turn on and off when editing worksheets that will protect
my formulas. Where is that device and or how do I enter data so that I won't
lose my formulas? Thanks