I suggest you ...

Cell Referencing

I am unable to find the way to prevent absolute cell copying in fill down or fill across, I tried formula($a2,b$1) but that doesn't work

1 vote
Vote
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
You have left! (?) (thinking…)
Bill DeWitt shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

2 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Bill DeWitt commented  ·   ·  Flag as inappropriate

    Perhaps more detail might get a response:
    I want -
    _ a b
    a aa ab
    b ba bb
    so I use concatenate($a2,b$1) which gives me aa in cell b2, but when I drag it out to fill I get (b2,c1) instead of (a2, c1) in cell b3 so that I get

    _ a b
    a aa aab

    when I drag it down I get a circular reference error warning.
    However -
    Going back to Google Sheets I was able to make the setup and download it as xls and import it and make it work, It seemed to read the "$" then.

Feedback and Knowledge Base