Column labels

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

How do I change column labels (A,B,C...) to custom labels (ex.,
year,wage,rate,etc.)?

TIA,
SN
 
Hi!

You can't!

You can choose to not display the column/row labels then enter your headers
in row 1 but you still have to use the default labels when creating formulas
and such.

For example: you couldn't use =year2 (referring to row 2 in the year column)

Biff
 
You cannot change the column and row headers.

What you can do is enter your labels in row 1 then hide the row and column
headers via Tools>Options>View>Row and column headers...uncheck it.


Gord Dibben Excel MVP
 
Thanks for the replies. I originally wanted to change the labels as i was
importing the Excel in to SAS. But I figured out a way to give the labels I
want in SAS. So, problem is solved.

Thanks Gord and Biff.

SN
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Removal Date 6
Copy corresponding cell in Column B if cell in A contains certain text? 1
Button & Labels text Anti-aliasing Problem using Windows Forms C# 0
Calculating with time 4
adding actual numbers in columns 3
Transpose stacked lists of values 1
Pulling data from multiple rows and columns 3
If statment help needed 1

Back
Top