How can i hide formulas in MS Excel

[Orton]

Hi guys, here i need some quick help from you all guys. I have a Data in Microsoft Excel 2003 with lots of formulas in every almost every cell. I have to present it in my office after few hours from now infront of my seniors. What i want is to not show the formulas in the edit bar of excel. Could you guys please make me how can i Hide the formulas in my Excel 2003 ?

[Glenny]

Hiding formulas in excel is very easy. Just go through this simple steps:-

1. Select the range of cells whose formulas you want to hide. You can also select nonadjacent ranges or the entire sheet.
   
   
2. On the Format menu, click Cells, and then click the Protection tab.
   
   
3. Select the Hidden check box.
   
   
4. Click OK.
   
   
5. On the Tools menu, point to Protection, and then click Protect Sheet.
   
   
6. Make sure the Protect worksheet and contents of locked cells check box is selected.

This formula is applicable for Excel 2007 as well.

[Orton]

Thanks a lot for such a quick reply and guiding me in simple steps. Help appreciated. In case if i need to to display the formulas again, what should i do ? Please let me know the process to unhide the formula as well. Thank you again.

[Raine]

To unhide the hidden formulas in excel, follow this few simple steps:-

• On the Tools menu, point to Protection, and then click Unprotect Sheet.
  
  
• Select the range of cells whose formulas you want to unhide.
  
  
• On the Format menu, click Cells, and then click the Protection tab.
  
  
• Clear the Hidden check box.

Thats it. You are done.