Forum Discussion
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 ...
Why do reference A3:C3 if you want data from A2:C2?
In B2:
='Group Calendar'!A3And copy to the right.
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.
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.
That means your Excel doesn't support dynamic arrays. Simplest way add to B2 ='Group Calendar'!A2 and drag to the right.
- Thanks Sergei. Is there a way to get my excel to support dynamic arrays? Because I have a LOT of these. Thanks.
In addition, Excel 2021 comes very soon What's new in Excel 2021 for Windows (microsoft.com)
However, if you are more or less active user of Excel I'd strongly recommend subscription model (Office 365). With 2021 you'll have relatively full set of modern functionality for now, but in few months it'll be behind 365, gap will be growing and you have to wait another couple of years to update on functionality which 365 to this moment has long ago.
