View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
malcolm malcolm is offline
external usenet poster
 
Posts: 57
Default Lock in formulas

I have a worksheet that I use over-and-over again. It has several columns of
data, and some of the columns have long and hard to remember formulas to
total the columns. I usually delete the numbers in the columns after I print
out the worksheet, leaving the formulas intact at the bottom of the columns.
Being human, I occasionally goof and delete the sum formulas too. Is there a
way that I can lock the formula cell at the bottom of the column so that I
don't accidentally delete it?

Thanks in advance,
Malcolm