Google sheets allows you to set a particular cell as variable so I can set A1=JimsHeight

But is there a way to name an entire column and use it as varaible?

Then I might set A = height so that I can use height1, height2 to represent A1, A2 etc. in a formula?

CodePudding user response：

No, I might set A = height so that I can use height1, height2 to represent A1, A2 etc. in a formula? is not possible.

What you can do is giving height to the header (i.e. A1) of the column, then use for instance

=offset(height,2,)

for A3

CodePudding user response：

You could do the following:

• Add a named range for your column (see
  • Call