Renaming columns and rows in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can we rename columns A, B,C etc. in Excel to user definable names? Similarly for rows?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

rename column header 2
Having Blank Cells, etc. ? 1
Showing Letters For Column Headers Rather Thann Numbers ? 1
In Excel, how do I rename the gray rows/columns (1,2,3/A,B,C)? 1
counting blank cells within two columns 2
Return MAX value from column B and Name from column A 2
Transpose, but how? 0
Excel Help to copy information from one row at a time to another sheet 1

Back
Top