Forum Discussion

gabrielsolomon7's avatar
gabrielsolomon7
Copper Contributor
Sep 30, 2021

Cell references do not display

Hello,   I think my question is so simple that no one has ever posted an answer to it.   I am trying to reference a range of cells from another sheet in the same workbook. In my current sheet, I ...
excel
Formulas and Functions
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Sep 30, 2021

gabrielsolomon7 

Why do reference A3:C3 if you want data from A2:C2?

 

In B2:

='Group Calendar'!A3

And copy to the right.

 

  • gabrielsolomon7's avatar
    gabrielsolomon7
    Copper Contributor
    Sep 30, 2021
    Hello, thanks for replying,

    I'm trying to get sheet 1 data A2:C2 to display in sheet 2 B2:D2. When I enter ='Group Calendar'!A2:C2 only the data from the leftmost cell is displayed.
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Sep 30, 2021

      gabrielsolomon7 

      That means your Excel doesn't support dynamic arrays. Simplest way add to B2 ='Group Calendar'!A2 and drag to the right.

      • gabrielsolomon7's avatar
        gabrielsolomon7
        Copper Contributor
        Sep 30, 2021
        Thanks Sergei. Is there a way to get my excel to support dynamic arrays? Because I have a LOT of these. Thanks.

Resources