hiding huge formula's in an excel sheet
You could hide the column so it will not be visible.
You could use Format | Cells | Protection (tab) on the cells
containing the formula and check both Locked and Hidden - if you then
protect the sheet (with or without a password) then you will only see
the result of the formula, not the formula itself.
Hope this helps.
Pete
On Jul 3, 4:26 pm, sandert wrote:
Hello,
One of collegue's had made an excel sheet with a huge formula.
When you open the excel sheet you see the huge formula wich stands in the
content of the sheet
Is the anyway to hide the formula ?
|