Forum Discussion

Copper Contributor

Apr 10, 2021

Solved

Using named range without auto spill

Hi, In the attached spreadsheet I have defined 'Data' as a range name for three numbers in a column A. I want to put the content of cell A2 into B2 using =Data (rather than =A2). However, the formul...

Test.xlsx10 KB

excel

Formulas and Functions

office 365

Riny_van_Eekelen
Apr 10, 2021
AlistairD Not sure why you would want to do that but try this:
=@Data

Riny_van_Eekelen

Platinum Contributor

Apr 10, 2021

AlistairD Not sure why you would want to do that but try this:

=@Data

AlistairD
Copper Contributor
Apr 10, 2021
Perfect. Thanks so much Riny_van_Eekelen.