Block Out Formula Notification For Free

How to Get Rid of Green Arrows in Excel Office 365 (Visual Guide)Click on File in the upper left of your excel document.Click on Options in the lower left.Click on Formulas in the left navigation column.Uncheck the box that says Enable background error checking.Click the OK button to save.

To remove green triangles from your spreadsheet go to Ribbon. Click File > Options. Next select Formulas in the left sidebar. To turn green triangles off untick checkbox Enable background error checking.

When you lock formulas in Excel, the user can't make any changes to the cells with formulas. However, if that cell is selected, the formula in the cell would be visible in the formula bar.

Lock the cell by doing one of the following:Click the Error Checking button next to the cell, and then click Lock Cell.In the Error Checking box, click Lock Cell.

If a cell contains a formula that breaks a rule that Excel uses to check for problems, a triangle appears in the top-left corner of the cell. You can prevent these indicators from displaying. On the Excel menu, click Preferences. , and then clear the Enable background error checking check box.

To turn off these green triangles or auto-calculating checks, do the following:On the File tab, click the Options button:In the Excel Options dialog box, on the Formulas tab, scroll down to the Error Checking section and uncheck the option Enable background error checking:More items...

How to remove protection and unhide formulas in ExcelOn the Home tab, in the Cells group, click the Format button, and select Unprotect Sheet from the drop-down menu.Or, go to the Review tab > Changes group, and click the Unprotect Sheet button.Jan 14, 2016