How do i change column header from R[1] C format to A1 format?

L

lovnlife

I am not sure how to get the worksheet to show alpha in the columns and
formulas instead of numeric.
 
M

Mike H

Hi,

Tools|Options - general tab and uncheck R1C1
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
R

Rick Rothstein

In XL2003 and earlier... Tools/Options from the menu bar, click General tab,
uncheck the first item ("R1C1 reference style").
 
R

Rick Rothstein

And for XL2007, click Office Button, Excel Options Button, select Formulas
from the left hand listing and uncheck "R1C1 reference style" in the
"Working with formulas" section in the right hand listing.
 

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

Change the column designation from a numeric to an alpha 2
Format of column need to change back to Alpha not numeric 1
Column and Row Labels 1
change column header from numeric to alphac? 6
Problem with Column header ID being 1 2 3 etc instead of A B C etc 2
reference format and column name 1
How do I change the Excel Column Labels as back to alpha? 1
Worksheet has numeric column headings. Change to alpha headings? 1

Top