Copying a Range
 

I have a range of numbers with formulas that produce a certain result.
All I want to do is copy this range and make an exact duplicte of it
right beneath itself. Trouble is the formulas all change and it looks
completely different.

Is there an easy way?

Copying a Range
 

Suppose your range is A1:B10 and you want to copy it to A12:B22. You could
enter =A1 in cell A12 then copy across and down.

Or you could copy A1:B10, select A12 and click Edit/Paste Special Values.

Or you could select A1:B10, click edit/replace and replace the "=" with
"%%". This converts your formulae to text. Then copy/paste your range.
Then select A1:B22 and edit/replace the "%%" with "=" to convert back to
formulae.


"Peter" wrote:

I have a range of numbers with formulas that produce a certain result.
All I want to do is copy this range and make an exact duplicte of it
right beneath itself. Trouble is the formulas all change and it looks
completely different.

Is there an easy way?