EXCEL HEADINGS

  • Thread starter Thread starter MARIO
  • Start date Start date
M

MARIO

This is probably a simple question but:
My excel worksheets no longer display letters as column
labels. Instead they show numbers as column and row
labels. How do I change this back to show letters(
a,b,c,d,e...)
thanks!
 
MARIO said:
This is probably a simple question but:
My excel worksheets no longer display letters as column
labels. Instead they show numbers as column and row
labels. How do I change this back to show letters(
a,b,c,d,e...)
thanks!
Click to expand...

Tools > Options > General tab
Uncheck "R1C1 reference style".
 
Mario, tool, options, general, and uncheck R1C1 reference style

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
 
Back
Top