ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do I cahnge column headings from numbers to letters (https://www.excelbanter.com/excel-discussion-misc-queries/36583-how-do-i-cahnge-column-headings-numbers-letters.html)

Blairlyng

how do I cahnge column headings from numbers to letters
 


Niek Otten

ToolsOptions, General tab, uncheck R1C1 Reference style

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Blairlyng" wrote in message
...




Andy Wiggins

Tools Options: General, then uncheck "R1C1 reference style", and click on
OK

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"Blairlyng" wrote in message
...




KL

Hi,

menu ToolsOptions, tab 'General', uncheck option 'R1C1 reference style'.

Regards,
KL

"Blairlyng" wrote in message
...




Blairlyng

Thank you so much Niek, you have saved my day. feel free to e-mail me when
you want to visit Scotland paul

"Niek Otten" wrote:

ToolsOptions, General tab, uncheck R1C1 Reference style

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Blairlyng" wrote in message
...






All times are GMT +1. The time now is 11:17 PM.

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