Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do you copy RANK w/o it changing the range?
How do you copy RANK w/o it changing the range when you are copying multiple
cells on a worksheet in Excel 2003? |
#2
|
|||
|
|||
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 "jspan" wrote in message ... How do you copy RANK w/o it changing the range when you are copying multiple cells on a worksheet in Excel 2003? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create range bar graph | Charts and Charting in Excel | |||
Macro to copy range from Excel files in folder | Excel Discussion (Misc queries) | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Copy Function | Excel Discussion (Misc queries) | |||
HOW DO I COPY FORMULA WITHOUT CHANGING CELL REFERENCE | Excel Discussion (Misc queries) |