Question

In excel a range can be entered by lying the beginning cell reference,and the ending cell reference then what

Answer 1

Copy an Excel formula without changing its cell references

Click on the cell containing the formula you want to copy.Press [F2].
Click and drag to select the entire formul
a.Click the Copy button in the Standard toolba
r.Press [Enter].
Select the cell into which you want to paste the formula
.Click the Paste button in the Standard toolbar.