On most versions of Excel you can find this by clicking the Home tab at the top of the Excel. Copy Excel formulas without changing references via Notepad Enter the formula view mode by pressing the Ctrl shortcut or by using any other method described in How to show. Actually you and use shortcut keyboards to archive it easily in Excel.
Alternatively click the fill handle in the source cell and drag it over the target cells.
Copying a Formula Exactly 1. Select all the cells to which you wish to copy the formula. Find and replace with another. Copy Excel formulas without changing references via Notepad Enter the formula view mode by pressing the Ctrl shortcut or by using any other method described in How to show.