What exactly do you mean by "list"?

The cell references changing, or remaining constant are pertinent when they
are within a formula.
You can change *all* cell references in a formula with a *single* click of
<F4 if you select the entire formula in the formula bar.

If you're not talking about cell references in a formula, would you care to
elaborate a little in your explanation?


--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------


"art" wrote in message
...
How can I change a whole list of cell reffernce to an absolute reference.
For
E.G. I have A1 A2 A3 A4 A5 B1 B2 B3 B4 B5 C1 C2 C3 C4 C5. How can I Change
the whole list at once to: $A$1 $A$2... and so on?