convert to absolute references

[Lenny]

I have a file with up to 11 seperate sheets. The sheets track the
results of team games, scores, points for and against and some other
stuff. I cut and paste special a link from each sheet to a seperate
sheet where i want to sort on the team results. Right now i copy the
results page and paste special values. Of course i can only do this
when the tournament is over.

I want to be able to sort during the day so I need to paste absolute
references. i can do this one cell at a time but it would take a very
long time to do each cell individually.

Is there a way to paste absoulte references or change a range of cells
to absolute?

Thanks,

Lenny

 

[JE McGimpsey]

Is there a way to paste absoulte references or change a range of cells
to absolute?

Edit/Paste Special, click on Paste Link.