Renaming a column label

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
 
J

J.E. McGimpsey

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
 

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

Trying to create custom labels from an csv file + Need items numerically counted out 0
Blank Page After Envelope-Label Wizard 5
ASK Field Formatting 1
How to center adjust text above and image in a two column document. 1
Automation of scanned file storage based on content 0
Two columns followed by single page-width column on same page 0
Label alignment of XY-plot, center is a bit off. Any ideas? 0
I screwed up 0

Top