Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Column labels
Hello,
How do I change column labels (A,B,C...) to custom labels (ex., year,wage,rate,etc.)? TIA, SN |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Column labels
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 "SN" wrote in message ... Hello, How do I change column labels (A,B,C...) to custom labels (ex., year,wage,rate,etc.)? TIA, SN |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Column labels
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF/AND/OR/DATEIF Issue...sorry...long post... | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
Is it possible to use Autofilter, when column labels not in Row 1? | Excel Discussion (Misc queries) | |||
Align Clustered Column Chart Category Axis Labels | Charts and Charting in Excel |