Hide Formulas in Excel & Show Values | Don't Show Formula in Formula Bar but Allow Input
In this video, I demonstrate how to hide formulas in your worksheet. The 'hidden' attribute is a formatting attribute and can be applied on a cell by cell basis. Once hidden a formula will not appear in the formula bar.
The hidden attribute only comes into effect once sheet protection has been applied. If you want to be able to edit cells once worksheet protection has been applied, you will need to unlock cells.
Another method you can use for hiding formulas is to convert them to values. This way the answers to the formulas are visible on the worksheet but the formulas behind them are discarded.
------------------------
Watch video Hide Formulas in Excel & Show Values | Don't Show Formula in Formula Bar but Allow Input online without registration, duration hours minute second in high quality. This video was added by user Chester Tugwell 06 April 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 68,145 once and liked it 311 people.