Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi,
Usually, the rows are numbers and the colums letters. Right now, my columns are numbers also. How can I get it fixed because this is really confusing for formulas. Thank you. |
#2
![]() |
|||
|
|||
![]()
Tools Options GeneralTab..........uncheck the R1C1 reference style
box............. Vaya con Dios, Chuck, CABGx3 "adel" wrote in message ... Hi, Usually, the rows are numbers and the colums letters. Right now, my columns are numbers also. How can I get it fixed because this is really confusing for formulas. Thank you. |
#3
![]() |
|||
|
|||
![]() Hello Adel, On the Excel Toolbar select: Tools | Options | General (tab) | Settings | R1C1 Reference Style (check box) Click the Check Box. The Check Mark will disappear. Click OK and your Columns will display letters again instead of numbers. Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=381396 |
#4
![]() |
|||
|
|||
![]()
Hi Adel. Go to Tools - Options and on the General Tab, deselect "R1C1"
reference style. HTH -- Sincerely, Michael Colvin "adel" wrote: Hi, Usually, the rows are numbers and the colums letters. Right now, my columns are numbers also. How can I get it fixed because this is really confusing for formulas. Thank you. |
#5
![]() |
|||
|
|||
![]()
Tools--Options--General tab. Untick R1C1 reference style.
******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "adel" wrote in message ... Hi, Usually, the rows are numbers and the colums letters. Right now, my columns are numbers also. How can I get it fixed because this is really confusing for formulas. Thank you. |
#6
![]() |
|||
|
|||
![]()
Thanks everyone. You were very helpful.
Adeline |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
chart label reference based on the column number | Charts and Charting in Excel | |||
chart label reference based on the column number | Charts and Charting in Excel | |||
Change Text to a number | Excel Worksheet Functions | |||
How do I change the category axis number formatting in a Pivot Ch. | Charts and Charting in Excel | |||
Change the width of a single column in a column chart | Charts and Charting in Excel |