ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Lost Column Letters (https://www.excelbanter.com/excel-discussion-misc-queries/228745-lost-column-letters.html)


Lost Column Letters
 
I dont know, but I have lost the column headings. They are there, but they
are numbers. So my rows and columns both have numbers. How can I get column
a,b,c, etc back?

Marcelo

Lost Column Letters
 
Tools | Options | on General tab unable R1C1 reference stile

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Té" escreveu:

I dont know, but I have lost the column headings. They are there, but they
are numbers. So my rows and columns both have numbers. How can I get column
a,b,c, etc back?



Lost Column Letters
 
I'm using Excel 2007. Where is that option?

"Marcelo" wrote:

Tools | Options | on General tab unable R1C1 reference stile

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Té" escreveu:

I dont know, but I have lost the column headings. They are there, but they
are numbers. So my rows and columns both have numbers. How can I get column
a,b,c, etc back?


chefmike

Lost Column Letters
 
Opne the Office button in the upper left hand corner goto excel options;
click on formulas and uncheck the R1C1 checkbox.

"Té" wrote:

I'm using Excel 2007. Where is that option?

"Marcelo" wrote:

Tools | Options | on General tab unable R1C1 reference stile

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Té" escreveu:

I dont know, but I have lost the column headings. They are there, but they
are numbers. So my rows and columns both have numbers. How can I get column
a,b,c, etc back?



Lost Column Letters
 
Thank you soooooooo much!!!

"chefmike" wrote:

Opne the Office button in the upper left hand corner goto excel options;
click on formulas and uncheck the R1C1 checkbox.

"Té" wrote:

I'm using Excel 2007. Where is that option?

"Marcelo" wrote:

Tools | Options | on General tab unable R1C1 reference stile

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Té" escreveu:

I dont know, but I have lost the column headings. They are there, but they
are numbers. So my rows and columns both have numbers. How can I get column
a,b,c, etc back?



All times are GMT +1. The time now is 06:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com