Formulas

J

Jega-OZ

when I create a formula using cells from a different workbook, excel
automatically uses absolute cell reference. Is there a setting that could
change this to use relative cell refrence?
 
D

Dave Peterson

I've never seen one. That's the way excel works.

If you select the formula (or parts of the formula) in the formula bar, you can
hit F4 to cycle through 4 relative/absolulte addresses.
 

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

Cumulative formula for word table 0
Excel 2002: changing link formula from absolute to relative 3
Excel - Wich Function should I use? 1
Change a cell reference from relative to absolute 2
Turning off automatic calculation 0
relative references 2
Absolute and Relative Cell References 1
Excel does not accept text format! 0

Top