HOW DO I HIDE FORMULA IN A CELL

R

Riya

Hai,
When a formula is given to the cell for calculation, that formula must be
hidden. But, the calculation must be done.
 
K

kk

Format / Cells / Protection / Hidden

(or likewise - i don't have acess to the english version of excel....)
 
P

paul

highlight the whole row or column and right click>hide,or format the cell to
have white text (or whatever the backgrounf colour of that cell is)It may
baffle you or someone else in the future though!
 
M

macropod

Hi Paul,

Hiding the column/row hides both the formula and the result!!
Formatting the text to the same colour as the background doesn't hide the
formula either; only the result!!

The OP wanted to see the result, not the formula ... which is what kk's
solution provides.

Cheers
 
A

Arvi Laanemets

Hi

You have to set for all cells you want formula not to be visible the Hidden
property to True (check Hidden checkbox on Protection tab of Format Cells
window). In same place you also can set cell conents to be locked/unlocked
(user can't change contents of locked cell) - by default all cells are
locked.

Cell protection settings will be working only, when the sheet is protected.
I.e. set protection settings as you need, and after that protect the sheet
(with password or without as you like).
 
Top