Overview Chat Bike Members News Women
Viewing 4 posts - 1 through 4 (of 4 total)
  • Excel question – copying cells, formula changes
  • cakefest
    Free Member

    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 13 years ago
    thepurist
    Full Member

    Isn’t it just a case of using relative and absolute references, or am I missing something from the problem?

    Posted 13 years ago
    TheSouthernYeti
    Free Member

    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 13 years ago
    oliverd1981
    Free Member

    you can cut and paste the formula text from the formula bar, if there aren’t too many to do

    Posted 13 years ago
Viewing 4 posts - 1 through 4 (of 4 total)

The topic ‘Excel question – copying cells, formula changes’ is closed to new replies.

Overview Chat Bike Members News Women