ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to change the column heading back to ABCDE instead of numbers (https://www.excelbanter.com/excel-discussion-misc-queries/182847-how-change-column-heading-back-abcde-instead-numbers.html)

Chester

how to change the column heading back to ABCDE instead of numbers
 
Could u assit me in changing the column headings back to its standard settings.
instead of the column heading being ABCDEFG and so fort it says 1234567.
How do you change it back

dennis

how to change the column heading back to ABCDE instead of numbers
 
Tools - Options - General Tab - Uncheck R1C1 reference style

"chester" wrote:

Could u assit me in changing the column headings back to its standard settings.
instead of the column heading being ABCDEFG and so fort it says 1234567.
How do you change it back


Chester

how to change the column heading back to ABCDE instead of numb
 
Thank you Dennis

"Dennis" wrote:

Tools - Options - General Tab - Uncheck R1C1 reference style

"chester" wrote:

Could u assit me in changing the column headings back to its standard settings.
instead of the column heading being ABCDEFG and so fort it says 1234567.
How do you change it back



All times are GMT +1. The time now is 05:52 PM.

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