Best Math Formula website. Search anything about Math Formula in this website.
how to lock excel formula in cell. Then click OK to lock the cell formula in excel. Select the range of cells whose formulas you want to hide.
To hide the Formula bar simply click the View tab and then uncheck Formula Bar in the Show. In the format cells dialog box select the Protection tab. Select the range of cells whose formulas you want to hide.
Usually you wont want to disable the Formula bar unless viewers are working with a read-only file.
Click Ok Apply. Select the range of cells whose formulas you want to hide. Here are the steps to lock formulas in Excel explained in detail later on. Copy and paste the formula to other cells to have sales value.