close

I have a series of items and a total column. I just want to protect the
formula in the final sum cell. How do I do that without having to protect
the entire column?

Thanks,

1) Select the entire sheet with CRTL A, or by clicking where the row and
column header meet
2) Format | Cells -gt;Protection -gt; uncheck the Locked box
3) Select the 'magic' cell, use Format | Cells -gt;Protection -gt; check the
Locked box
4) Tools | Protection -gt; Protect sheet
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;Sue G.quot; lt;Sue gt; wrote in message
...
gt;I have a series of items and a total column. I just want to protect the
gt; formula in the final sum cell. How do I do that without having to protect
gt; the entire column?
gt;
gt; Thanks,

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()