Can I change the column heading from alphabetic to numeric?

L

Lunchbox18

I want to reference cells in a R1C1 format instead of A1. The heading diplay
of the columns should be numeric instead of alphabetic.
 
E

Elkar

In Excel 2003 or earlier versions:

Go to TOOLS, then OPTIONS
Select the GENERAL Tab
Check "R1C1 reference style" checkbox
Click OK

In Excel 2007:

Click the Office Button (big circle in upper-left)
Click on the EXCEL OPTIONS button
Select the FORMULAS Tab on the left
Check "R1C1 reference style" checkbox
Click OK

HTH
Elkar
 
C

Chris Bode

1. from the menu bar select tools>options
2. select general tab
3. put a check mark on the R1C1 Reference style
4. click OK


Chris
 

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

How: reset the column headings from numeric to alphabetic? 1
Need help modifying code 0
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
alter column ref 3
Problem with SET & REF function 0
How do change excel columns from alphabetic to numeric 1
Range headings 0
How do I change excel column heading from numeric to alphabetic? 2

Top