Copying a Range

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

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?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select a formula / range from Excel drop down suggestions 6
Automatically change ranges when copying formula 7
Macro to COPY FORMULA BETWEEN RANGES 1
Copying a split range 3
Conditional sum in a named range 8
How can I copy big ranges of cells without drag or copy/paste? 3
VLOOKUP copy and paste problem 2
Count cells in a range 2

Back
Top