Copying an entire row of formulas

[Lazer]

How do I copy all *forumlas* (without values) in row 10, for example, to
row 20?

In other words, if the forumla for cell W10 is "=+S10+U10", then the
when I copy the entire row of formulas to row 20, the formula for W20
should be "=+S20+U20", *not* "=S10+U10"

Thanks!
Eliezer

 

[Richard Buttrey]

On Wed, 11 Aug 2004 11:04:07 -0500, Lazer

RB>How do I copy all *forumlas* (without values) in row 10, for
example, to
RB>row 20?
RB>
RB>In other words, if the forumla for cell W10 is "=+S10+U10", then
the
RB>when I copy the entire row of formulas to row 20, the formula for
W20
RB>should be "=+S20+U20", *not* "=S10+U10"


I'm not quite clear what your problem is. "=+S10+U10" does convert to
"=+S20+U20" when copied to W20.

It sounds like you might have the cell references set to absolute. Are
you sure W10 doesn't have "=+$S$10+$U$10" ?

Rgds



RB>
RB>Thanks!
RB>Eliezer
RB>
RB>
RB>---
RB>Message posted

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________