ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Column Header Excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/128920-column-header-excel-2007-a.html)

Mark B

Column Header Excel 2007
 
Hi,
my column (grid) headers have changed to numeric from letters. Anyone
know how to change them back

Thanks

Mark

Roger Govier

Column Header Excel 2007
 
Hi

ToolsOptionsGeneraluntick R1C1 notation

--
Regards

Roger Govier


"Mark B" <Mark wrote in message
...
Hi,
my column (grid) headers have changed to numeric from letters.
Anyone
know how to change them back

Thanks

Mark




Roger Govier

Column Header Excel 2007
 
Hi Mark

Sorry, replied as per XL2003
for XL2007
Click Office buttonExcel OptionsFormulasWorking with formulasuntick
R1C1 reference style

--
Regards

Roger Govier


"Mark B" <Mark wrote in message
...
Hi,
my column (grid) headers have changed to numeric from letters.
Anyone
know how to change them back

Thanks

Mark




Mark B

Column Header Excel 2007
 
thanks

"Roger Govier" wrote:

Hi Mark

Sorry, replied as per XL2003
for XL2007
Click Office buttonExcel OptionsFormulasWorking with formulasuntick
R1C1 reference style

--
Regards

Roger Govier


"Mark B" <Mark wrote in message
...
Hi,
my column (grid) headers have changed to numeric from letters.
Anyone
know how to change them back

Thanks

Mark






All times are GMT +1. The time now is 01:24 PM.

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