Trick : Replica of Exact Set of Formula Range.

Replica of Exact Set of Formula Range.

If you want the Exact Range Set Formulas. Then, here we have the simple trick for it.

Steps:

a) Select a Range of Formulas. In our Example it's D9:E11

b) After selecting the range, Group the Sheet1 and Sheet2(Sheet2 is blank sheet)-Press Ctrl and Select Sheet2. From Home tab menu, Select Fill >> Across Workbook >> Select Fill option from dialogue box. Click OK.

c) In Sheet2, you can see the Formula Range Set. Ungroup Sheets. In sheet2 Range of Formulas Selected. Press Ctrl+X to cut the range.

d) Then, Activate the cell D12 in Sheet2. And Press Enter. You can see Formulas set shift downward.
e) Again, Group Sheet1 and Sheet2-Press Ctrl and Select Sheet1. From Home tab menu, Select Fill >> Across Workbook >> Select Fill option from dialogue box. Click OK.

And it is done here. You can see the Replica of Exact set of Formula range (sheet1~D9:E11) in sheet1~D12:E14.

Thank You !!