Is it normal that when I link cells from worksheets in different Workbooks
the formula is always an absolute address?
Is it normal that when I link cells from worksheets in different Workbooks
the formula is always an absolute address?
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
"rfhorn" <[email protected]> wrote in message
news:[email protected]...
> Is it normal that when I link cells from worksheets in different Workbooks
> the formula is always an absolute address?
Thank you for the response.
"Bernie Deitrick" wrote:
> 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
>
>
> "rfhorn" <[email protected]> wrote in message
> news:[email protected]...
> > Is it normal that when I link cells from worksheets in different Workbooks
> > the formula is always an absolute address?
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks