how to rename default column heading?

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

Guest

column heading in my MS excel now showing 1, 2, 3, 4, 5, ...
how to change the header default to A, B, C, D, ....
thanks
 
Noel,

Go to Tools/Options/General/
and uncheck R1C1 Reference Style

This Help?
 
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

Figuring out a lengthy formula. Probably quite simple... 3
Parts for my new build 10
Vlookup or similar 7
METRO 2039 Revealed 0
copy and paste + transpone 3
Unique #s in column, need multiple associated numbers in columns 5
Column headings question 5
Counting unique values in multiple columns 4

Back
Top