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.
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.
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
Tools > Options > GeneralTab..........uncheck the R1C1 reference style
box.............
Vaya con Dios,
Chuck, CABGx3
"adel" <adel@discussions.microsoft.com> wrote in message
news:3F87B0BE-F0FE-493E-AAEB-7ABDE6526334@microsoft.com...
> 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.
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.
Tools-->Options-->General tab. Untick R1C1 reference style.
*******************
~Anne Troy
www.OfficeArticles.com
www.MyExpertsOnline.com
"adel" <adel@discussions.microsoft.com> wrote in message
news:3F87B0BE-F0FE-493E-AAEB-7ABDE6526334@microsoft.com...
> 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.
Thanks everyone. You were very helpful.
Adeline
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks