ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Header names (https://www.excelbanter.com/excel-discussion-misc-queries/3640-header-names.html)

Mo

Header names
 
How do I change the column heading names? It was letters it is now numbers. I
would like it to be letter again. I have numbers going down the side.
(Numbering the rows) That is fine but some how I've changed all my worksheets
to numbers on the top row lableing the columns. Thank you for your help.

JulieD

Hi

tools / options / general - untick R1C1 reference style

Cheers
JulieD

"Mo" wrote in message
...
How do I change the column heading names? It was letters it is now
numbers. I
would like it to be letter again. I have numbers going down the side.
(Numbering the rows) That is fine but some how I've changed all my
worksheets
to numbers on the top row lableing the columns. Thank you for your help.




Norman Jones

Hi Mo,

Tools | Options | General Tab | deslect :R1C1 reference style"


---
Regards,
Norman



"Mo" wrote in message
...
How do I change the column heading names? It was letters it is now
numbers. I
would like it to be letter again. I have numbers going down the side.
(Numbering the rows) That is fine but some how I've changed all my
worksheets
to numbers on the top row lableing the columns. Thank you for your help.





All times are GMT +1. The time now is 04:42 AM.

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