ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Column headings (https://www.excelbanter.com/excel-discussion-misc-queries/121798-column-headings.html)

Teri

Column headings
 
I just opened up an excel file and am surprised to see that my columns
now have number headings rather than letter headings. Has anyone else
experienced this? If so, how did you rectify it? Please advise!!!


Don Guillett

Column headings
 
toolsoptionsgeneralr1c1
Perhaps a macro changed it?

--
Don Guillett
SalesAid Software

"Teri" wrote in message
ups.com...
I just opened up an excel file and am surprised to see that my columns
now have number headings rather than letter headings. Has anyone else
experienced this? If so, how did you rectify it? Please advise!!!




Jason Lepack

Column headings
 
Tools - Options - General Tab - R1C1 Reference Style

Make sure it's unchecked.

Cheers,
Jason Lepack

Teri wrote:
I just opened up an excel file and am surprised to see that my columns
now have number headings rather than letter headings. Has anyone else
experienced this? If so, how did you rectify it? Please advise!!!



Niek Otten

Column headings
 
ToolsOptionsGeneral tab, uncheck R1C1 reference style

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Teri" wrote in message ups.com...
|I just opened up an excel file and am surprised to see that my columns
| now have number headings rather than letter headings. Has anyone else
| experienced this? If so, how did you rectify it? Please advise!!!
|



Teri

Column headings
 

Thank you, thank you, thank you!!!!

Niek Otten wrote:
ToolsOptionsGeneral tab, uncheck R1C1 reference style

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Teri" wrote in message ups.com...
|I just opened up an excel file and am surprised to see that my columns
| now have number headings rather than letter headings. Has anyone else
| experienced this? If so, how did you rectify it? Please advise!!!
|



Don Guillett

Column headings
 
You're welcome 1

--
Don Guillett
SalesAid Software

"Teri" wrote in message
ps.com...

Thank you, thank you, thank you!!!!

Niek Otten wrote:
ToolsOptionsGeneral tab, uncheck R1C1 reference style

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Teri" wrote in message
ups.com...
|I just opened up an excel file and am surprised to see that my columns
| now have number headings rather than letter headings. Has anyone else
| experienced this? If so, how did you rectify it? Please advise!!!
|






All times are GMT +1. The time now is 03:29 AM.

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