column header labels are numbered but need to be lettered

  • Thread starter Thread starter solgash
  • Start date Start date
S

solgash

I need column heads to be lettered but both column and rows are numbered ..
help !
 
Which version of Excel are you using?

In 2007 go to the office button and down to Excel Options, in the formula
tab unselect the checkbox labeled R1C1 reference style.

I am sure the same checkbox exists in earlier versions under Tools, Options
in the menu bar.

Hth
Stu
 
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

Showing Letters For Column Headers Rather Thann Numbers ? 1
Row & Column Headings 2
column labels 2
In Excel I now have numbers instead of letters on column tops 1
Column header format 5
Delete a formula but leave the data. 2
convert columns from numbers to a lettering system 1
Column Labels 1

Back
Top