How to Hide Formulas in Excel

Excel Worksheet contains lot of formulas and Functions.  When ever your sending the file for review we need to hide the formulas from viewing.  Follow the steps to hide formulas

  1.  Select All the Cells in the entire worksheet [use Ctrl + A ].
  2. Home tab Format -> Format Cells -> Protection Tab and Uncheck the Locked and Hidden Check box.
  3. Select the Cells which contains Formulas and Functions.
  4. Home tab Format -> Format Cells -> Protection Tab and Check the Locked and Hidden Check boxes.
  5. Review Tab -> Protect Sheet Option
  6. Type Password to Protect the Sheet. [Note Only values are visible and Formula will be hidden]

Keep Learning
Win Corporate

Website: http://www.wincorptrg.com
profile: http://www.urbanpro.com/bangalore/vijayalakshmi-g-m/626432

Advertisements