How do you copy RANK w/o it changing the range?

J

jspan

How do you copy RANK w/o it changing the range when you are copying multiple
cells on a worksheet in Excel 2003?
 
B

Bernie Deitrick

That depends on which ranges. You could change the formula to a string
prior to the copy by inserting a single quote before the = sign, then copy,
paste, and delete the quote mark. Or, possibly, you could use absolute
range references on one or more of the range references (that means A1:A100
should look like $A$1:$A$100)

HTH,
Bernie
MS Excel MVP
 
Top