Question

options used to copy a formula from one cell to another

Answer 1

How to copy an Excel formula but not formatting

Select the sell containing the formula.

Copy that cell by pressing Ctrl + C. Alternatively, right click the cell and select Copy from the context menu, or click the Copy button on the Home tab > Clipboard.

Select all the cells to which you want to copythe formula
hope it will help you

Answer 2

Select the sell containing the formula.

Copy that cell by pressing Ctrl + C. Alternatively, right click the cell and select Copy from the context menu, or click the Copy button on the Home tab > Clipboard.

Select all the cells to which you want to copy the formula.