Once youre done close this window and return to the main Excel window. If you entered as the first character in the cell but didnt intend to enter a formula you can type an apostrophe. A disadvantage of this new notation arises when you try to copy the formula to the neighbouring columns.
A formula cell has a leading space or apostrophe before the equal sign.
Go to the Protection tab on this window and enable both the Lock and Hidden option. Select the range of the cells where you have formulas. If on row 2 your formula in L2 is P2-AF2 then you can replace this with P2-OFFSETL2020. Click the cell that you want to insert the formula go to the Formulas tab and from the tools ribbon click Insert function Look for and click the function on the list and then click the Ok button.