Column labels

S

SN

Hello,

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

TIA,
SN
 
B

Biff

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
 
G

Gord Dibben

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
 
S

SN

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
 
Top