Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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, |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
1) Select the entire sheet with CRTL+A, or by clicking where the row and
column header meet 2) Format | Cells -Protection - uncheck the Locked box 3) Select the 'magic' cell, use Format | Cells -Protection - check the Locked box 4) Tools | Protection - Protect sheet best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Sue G." <Sue wrote in message ... 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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
In excel how do I protect the format of a cell but let the user c. | Excel Discussion (Misc queries) | |||
Can you reference a cell that is sorted in excel 2002? | Excel Worksheet Functions | |||
How can I copy a list from word into a single cell in excel | Excel Discussion (Misc queries) | |||
Excel 2002 "Protect Sheet", but Allow "Insert Comments"? | Excel Worksheet Functions | |||
Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) |