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
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Bill DeWitt shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    2 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      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