![]() ![]() On the Review ribbon, find the button labeled either Protect Sheet or Unprotect Sheet.Luckily, Excel makes it fairly simple to hide formulas. I don’t want them to know how other producers’ rates are calculated. On occasion I need to send the same spreadsheet to a list of competing vendors. Perhaps you need to hide Excel formulas from recipients and users for proprietary, security, or confidentiality reasons. If that’s not enough, you can select the Formulas ribbon and click Evaluate Formulas for a step-by-step walkthrough.īut what happens when you don’t want the formulas displayed? If you are working with a lot of complexity, it can get cluttered or confusing fast. When you click on the cell, the formula is displayed in the formula bar. By Christy Perry Categories: Formulas Tags: Excel Formulas, Hide FormulasĮxcel makes it easy to decipher why a formula produces its result.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |