Hi my name is XXXXX XXXXX X will be assisting you with your problem today!
Can you tell me what program you are using?
Thanks, XXXXX XXXXX what I am understanding you want to label your columns with a title correct?
To do so you need to use row 1 of your worksheet as the column label and what you can do is to turn your data into a table
Take a look at this tutorial on using the table feature in Excel: http://office.microsoft.com/en-us/excel-help/quick-start-create-an-excel-table-HA010359200.aspx
I understand how to do that - What I am attempting to determine is IF I can change A to a label, and B to a Label, etc.
Columns are numbered and lettered such that the spreadsheet is in a grid form
A1 is always the top left
Understand that, I am working with someone who believes otherwise. I suppose if I hide labels then it would appear that the top row is my Label row.
Let me double check that in my excel (loading)
You can change the Column label
but it will still be identified as "A"
But you can type in a name to the column in the top left corner
Once you have the column selected
So if you select all of A or all of B
the top left cell has A1 or B1 etc
you can change the column label to something else
but the column will still remain A
A1,A2,A3 etc for the cells
despite the label of column A being something else
This is true for cell labels too
This allows you to reference the cell by the label
OK - Confirms what I thought. thanks.
So if I named "A2" as "Racoon"
I can now call another cell =(Racoon)
and it will get Racoon or A2's value
But Racoon is equal to A2
=(Racoon) or =(A2) will return the same result
does that make sense?
So the labeling is just aliasing the column, row, or cell
Understood - I have been using Excel for several years. When someone with a Ph.D. says you can change A to Label name you think twice.
but the absolute coordinates are still the base reference
Understood. You have answered my question.
Great, hope that has helped.
Let me know if that helps!
If it does please take a moment to rate our interaction to close this question.
If you have further questions, please feel free to ask them below and I will gladly continue to assist you!