Absolute values

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
 
V

Vasant Nanavati

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Match table shading (color) to Visio color/Transparency 1
Conditional formatting - multiple criteria 4
Absolute Reference Changes 2
Automatically populate value of cell dependent on adajecent cell 3
Formula autofill to cells below – formula arguments are cell areas in different columns 1
Multiply with Vlookup value from another Worksheet 0
Absolute value conditional formatting 4

Top