Thread: Column labels
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SN
 
Posts: n/a
Default Column labels

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

"Gord Dibben" wrote:

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 ToolsOptionsViewRow and column headers...uncheck it.


Gord Dibben Excel MVP

On Tue, 22 Nov 2005 19:22:01 -0800, "SN" wrote:

Hello,

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

TIA,
SN