Formula question

[cwhiteheadjr84]

Hello everyone I know that once you enter a formula into a cell you can drag it down to fill in to all the cells under it. My question is in certain cells i have a different formula in it and was wondering if there was something i could put into the formula to prevent it from changing when i drag a different formula cell over it.

 

[DanteAmor]

You can block the cells that you do not want to modify, such as the cells that have formula and then protect the sheet.
If you want to write something about a locked cell and with the protected sheet, Excel will not allow you.