S
Sib Daspal
Can we rename columns A, B,C etc. in Excel to user definable names? Similarly for rows?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Andy B
Sib
No you can't. It is fixed. The only easy workaround is to put your own
headings in and use Window/Freeze Panes so they show wherever you are on the
sheet.
Andy.
No you can't. It is fixed. The only easy workaround is to put your own
headings in and use Window/Freeze Panes so they show wherever you are on the
sheet.
Andy.
Similarly for rows?Sib Daspal said:Can we rename columns A, B,C etc. in Excel to user definable names?
G
gocush
As Andy suggests you can enter "LABELS" at the top of columns or at the
left of rows to give you a "visual" clue.
However, your question was: can we RENAME colums and rows?
NAMING a range in excel has a different meaning. If you want to give a
NAME to col A, select the col / select the NameBox/type your Name/click
OK.
Now you can refer to col A by using your Name in formulas and in vba
code: range("MyName")
left of rows to give you a "visual" clue.
However, your question was: can we RENAME colums and rows?
NAMING a range in excel has a different meaning. If you want to give a
NAME to col A, select the col / select the NameBox/type your Name/click
OK.
Now you can refer to col A by using your Name in formulas and in vba
code: range("MyName")
J
JMay
Don't forget that you can enter as labels your "own" column (B1:Z1) headers
and row headers (A2:A20) and then go to Tools, Options, View Tab, and
uncheck Under Window Options "row & column headers" ..
JMay
and row headers (A2:A20) and then go to Tools, Options, View Tab, and
uncheck Under Window Options "row & column headers" ..
JMay