how do i change the column headings from numbers to letters

W

walty

I have just changed to excel 2007 - cant find the r1c1 tab to change the
column heading from numbers to letters - can anyone help
 
P

Peo Sjoblom

Click the office button (upper left), select Excel Options>formulas


Regards,

Peo Sjoblom
 
B

Bernard Liengme

The column headers should be letters after you installed XL2007; that is the
default.
To get numbers and use the R1C1 style;
1) click the Office Button (colourful circle in top left corner of Excel
window)
2) click Excel Options button located at bottom of resulting panel
3) In left panel of next window, click Formulas
4) In the second grouping down "Working with Formulas", the first selection
box is labelled R1C1 reference style
best wishes
 

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

Top