Renaming columns and rows in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
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.

Sib Daspal said:
Can we rename columns A, B,C etc. in Excel to user definable names?
Click to expand...
Similarly for rows?
 
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")
 
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
 
Back
Top