Absolute address in Workbook linking

R

rfhorn

Is it normal that when I link cells from worksheets in different Workbooks
the formula is always an absolute address?
 
B

Bernie Deitrick

Yes, that's the default behavior of Excel. Just get into the habit of
hitting F4 one, two, or three times prior to hitting enter, to change the
reference type.

HTH,
Bernie
MS Excel MVP
 
R

rfhorn

Thank you for the response.

Bernie Deitrick said:
Yes, that's the default behavior of Excel. Just get into the habit of
hitting F4 one, two, or three times prior to hitting enter, to change the
reference type.

HTH,
Bernie
MS Excel MVP
Click to expand...
 
Top