Solved: How to hide Formulas

[rahullambe]

I want to know that how to lock and hide formulaes in excel also how to protect i mean "lock" individual cell.

Thanks

[Bob Phillips]

Unlock all cells, Ctrl-A, Format>Cells>Protection - uncheck Lock

Select cells to hide, Format>Cells>Protection, check lock and check Hide

Protect sheet, Tools>Protection

[Kenneth Hobs]

Ctrl+1, Proctection, Locked and Hidden. You must also protect the sheet for it to work.

[mdmackillop]

You'll find a lot more information on these basic functions in the Help file.

[rahullambe]

Unlock all cells, Ctrl-A, Format>Cells>Protection - uncheck Lock

Select cells to hide, Format>Cells>Protection, check lock and check Hide

Protect sheet, Tools>Protection

[rahullambe]

Ctrl+1, Proctection, Locked and Hidden. You must also protect the sheet for it to work.

[Aussiebear]

Hi rahullambe, Please use the Thread Tools option to mark you thread as solved, rather than adding it in as a part of a post title.