ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   naming a column (https://www.excelbanter.com/excel-discussion-misc-queries/235904-naming-column.html)

wolffjrs

naming a column
 
How do I give a name to a column, rather than just leaving it as "A", "B",
"C", etc.? If, for example, I want column A to be for items and column B to
be for prices, how do I change the "A" at the top to read "item" and the "B"
to read "price"?

Max

naming a column
 
You can't. Just use the 1st row to name your column headers, ie in B1 across
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---


"wolffjrs" wrote:

How do I give a name to a column, rather than just leaving it as "A", "B",
"C", etc.? If, for example, I want column A to be for items and column B to
be for prices, how do I change the "A" at the top to read "item" and the "B"
to read "price"?


Jacob Skaria

naming a column
 
You cannot. Usually the header text is placed in the top row of your data
(say Row1).

However you can name a range..to refer in formulas..Refer
http://www.contextures.com/xlNames01.html

If this post helps click Yes
---------------
Jacob Skaria


"wolffjrs" wrote:

How do I give a name to a column, rather than just leaving it as "A", "B",
"C", etc.? If, for example, I want column A to be for items and column B to
be for prices, how do I change the "A" at the top to read "item" and the "B"
to read "price"?



All times are GMT +1. The time now is 07:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com