When you copy and paste a range of cells that contain formula, Excel will adjust the relative cell references in the copied formula automatically. With Kutools for Excel’s Exact Copy feature, you can quickly copy and paste the exact formula without changing the relative cell references.

Usage

1. Before using Exact Formula Copy, select the range of cells you want to copy.

2. Click Kutools >> Formula >> Exact Copy. See Screenshot (Fig.1).

Fig.1 Exact Formula Copy

3. Make sure that the Copy from box contains the correct range you want to copy, or click the button to reselect the range. See Screenshot (Fig.2)

4. Specify the Copy to location. See Screenshot (Fig.2)

Tip:

You can choose to copy the cells formatting by placing a checkmark at the Copy formatting.

Fig.2 Specify the formula copy

5. Click OK.

Notes:

The workbooks to be selected should be saved and activated.

This is only one feature of Kutools for Excel

It includes more than 100 functions and tools for Excel 2007 and 2010.