Add Formula Permit For Free

Find cells that have data validation rulesOn the Edit menu, point to Find, and then click Go To.Click Special.Select Data Validation.To find all cells with data validation, select All, and then click OK. To find cells that have the same validation rules as another cell, select Same, and then click OK.

Create a simple formula in ExcelOn the worksheet, click the cell in which you want to enter the formula.Type the = (equal sign) followed by the constants and operators (up to 8192 characters) that you want to use in the calculation. For our example, type =1+1. Notes:Press Enter (Windows) or Return (Mac).

On the Home tab, click the Format Cell Font popup launcher. You can also press Ctrl+Shift+F or Ctrl+1. In the Format Cells popup, in the Protection tab, uncheck the Locked box and then click OK. This unlocks all the cells on the worksheet when you protect the worksheet.

Create a drop-down listSelect the cells that you want to contain the lists.On the ribbon, click DATA > Data Validation.In the dialog, set Allow to List.Click in Source, type the text or numbers (separated by commas, for a comma-delimited list) that you want in your drop-down list, and click OK.

Lock or Unlock CellsSelect the cells you want to unlock.Click the Format button on the Home tab.Select Format Cells.Click the Protection tab.Clear the Locked check box. You can also toggle the lock on and off by clicking the Format button and selecting Lock Cell.Click OK.

How to do calculations in ExcelType the equal symbol (=) in a cell. This tells Excel that you are entering a formula, not just numbers.Type the equation you want to calculate. For example, to add up 5 and 7, you type =5+7.Press the Enter key to complete your calculation. Done!Jun 21, 2017

First, select the column, row, or set of cells that will be affected by your validation. Next, go to Data > Data Validation. This will open up the menu bar. Under Criteria, select Custom Formula is and then enter the formula you'd like to use.