Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I make the collumn headers in excel be letters rather tha.
I have just changed laptops and now excel shows its cell references as R1C1
for cell A1 how do i make it use letters for collumns? |
#2
|
|||
|
|||
Tools - Options - General and uncheck the R1C1 display
"Ian Hunt" wrote: I have just changed laptops and now excel shows its cell references as R1C1 for cell A1 how do i make it use letters for collumns? |
#3
|
|||
|
|||
Go to Tools Options. General Tab. Uncheck the box that
reads "R1C1 reference style". HTH Jason Atlanta, GA -----Original Message----- I have just changed laptops and now excel shows its cell references as R1C1 for cell A1 how do i make it use letters for collumns? . |
#4
|
|||
|
|||
Toolsoptionsgeneral and uncheck R1C1 reference style
-- Regards, Peo Sjoblom "Ian Hunt" <Ian wrote in message ... I have just changed laptops and now excel shows its cell references as R1C1 for cell A1 how do i make it use letters for collumns? |
#5
|
|||
|
|||
Hi Ian,
Go into Tools, Options and the General Tab. In there untick the R1C1 reference style. This should then solve your problem. Chris "Ian Hunt" wrote: I have just changed laptops and now excel shows its cell references as R1C1 for cell A1 how do i make it use letters for collumns? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make one CSV file from two Excel sheets? | Excel Discussion (Misc queries) | |||
can I make pulldown text boxes in excel sheets | Excel Discussion (Misc queries) | |||
Excel opens my file and a book1.xls, make it stop? | Excel Discussion (Misc queries) | |||
Excel Headers while scrolling down | Excel Discussion (Misc queries) | |||
Make copy from any document into Excel a right click with a drop . | Excel Worksheet Functions |