Forum menu
Topic starter
I have a range of cells that are included in formulae.
I'd like to copy those cells, and have them reference the same source cells for the formulae.
Is there an easy way to do that without recreating the formulae at all?
Thanks.
Posted : 30/11/2010 10:19 am
Isn't it just a case of using [url= http://www.ozgrid.com/Excel/free-training/excel-lesson-16-basic.htm ]relative and absolute[/url] references, or am I missing something from the problem?
Posted : 30/11/2010 10:26 am
Purist may well have this one sewn up for you.
It is also possible to drag cells about and maintain the original references without putting $ signs everywhere if that's easier for you.
Posted : 30/11/2010 10:43 am
you can cut and paste the formula text from the formula bar, if there aren't too many to do
Posted : 30/11/2010 10:54 am