how can i hide the formulas in excel?

hi..everybody.

i knw after seeing headline on my post u guys will think this is so silly but for me its little tough. becoz i knw how to hide. but if i hide the formulas it will affect to whole sheet. we cant edit. so i like to hide formulas only and it have to allow others to format that worsheet.

i did this before..for hide formulas

First, to i change the attributes, select the appropriate cell or range and then choose Format, Cells. In the Format Cells dialog box, click the Protection tab and select Locked or Hidden (or both). Unlock cells that accept user input, and lock formula and other cells that should stay unchanged (such as titles). To prevent others from seeing your formulas, lock and hide the formula cells: The results of the formulas will be visible, but the formulas will not.

Now, to protect the worksheet, choose Tools, Protection, Protect Sheet to bring up the Protect Sheet dialog box.
but its hideing the formulas. once i protect the cells it wont let me to edit the worsheet (eg- cell height, cell width)

thats correct so far but make sure you choose the attributes you want to be allowed as editable
such as select :-
locked
unlocked

format:-
cells
columns
rows.

thank u for reply..

but i didnt understand ur answer. my steps r ok?

i selected I4:n1381 (all these cell contains formulas) once i put protect...password...i cant change edit the cell size also.

plz help me.

check my example sheet and make it correct. otherwise i willsend u other protected worsheet.

see attached changes made in second image after cells protected and saved

thank u very much..[/SIZE][/B][/COLOR]