how do I put in a name for the columns?

A

asdf

I need to put in a name for the columns. But I don't want the names to be
part of the data in the columns, just want it to be a name.

How do I do that?
 
M

Ms-Exl-Learner

Just select the column or columns and press Cntrl+F3 and give the name you
want and press ok. Now use the defined name in your formula.

For Example:-

Select the B to E and press Cntrl+F3 and give the desired name as ABC and
give Ok.

And use the defined name in your formula like this.
=SUM(ABC)
This will total the Numeric values which are all available in B to E Column

If this post helps, Click Yes!
 
M

Ms-Exl-Learner

Just select the column or columns and press Cntrl+F3 and give the name you
want and press ok. Now use the defined name in your formula.

For Example:-

Select the B to E and press Cntrl+F3 and give the desired name as ABC and
give Ok.

And use the defined name in your formula like this.
=SUM(ABC)
This will total the Numeric values which are all available in B to E Column

If this post helps, Click Yes!
 
Top