Hiding Excel formulas for presentations

[Perry_Holden]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I am trying to create an excel file for a customer and want to be able to show them, without them seeing the formulas building the sheet. Is there any way to do this??

 

[CyberTaz]

Select the cells involved, go to Format> Cells - Protection, check the
Hidden checkbox. The formulas will not display once you protect the sheet
(Tools> Protection> Protect Sheet).

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[JE McGimpsey]

Select the cells involved, go to Format> Cells - Protection, check the
Hidden checkbox. The formulas will not display once you protect the sheet
(Tools> Protection> Protect Sheet).

Just note that this 'protection' is incredibly easy to bypass:

http://mcgimpsey.com/excel/removepwords.html

You should always assume that if you send someone a workbook, they'll
have access to everything in it.