Renaming a column label

  • Thread starter Thread starter Mike Warner
  • Start date Start date
M

Mike Warner

How do I rename the column header labels from "A", "B", etc. to
something else? Made a valiant effort. Can't figure it out.

Mike
 
Short answer: you don't - that capability (other than using numbers
- check the Tools/Options/General R1C1 reference style checkbox)
doesn't exist in XL.

Longer answer: If you hide the row and column headers
(Tools/Options/View) you can format Row 1 for column headers. You
can even use those labels in formulas, though it can get tricky: See
"About labels and names in formulas" in XL Help
 
Back
Top