View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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 ?