Absolute values

  • Thread starter Thread starter Hayden
  • Start date Start date
H

Hayden

Hello all

I want to be able to set absolute values in an excel
s/sheet over a number of cells at the same time.
I know if you select the formula and press (F4) $
(absolutevalues) will appear. I cant however get this
across multipil cells at the same time. Can anyone help?

Regards

Hayden
 
Hi:

It can't be done, unless the formulas are the same (in relative form) in all
the cells that you are selecting.

Regards,

Vasant.
 
Back
Top