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

Excel 2002: changing link formula from absolute to relative 3
Change a cell reference from relative to absolute 2
Absolute and Relative Cell References 1
relative references 2
References to external workbooks in excel 2
Default reference type 3
Change relative to absolute references in a block of cells 3
Filling Formulas 2

Top