ExcelBanter - how do i change the column headings from numbers to letters in ex

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do i change the column headings from numbers to letters in ex (https://www.excelbanter.com/excel-discussion-misc-queries/67429-how-do-i-change-column-headings-numbers-letters-ex.html)

N C

how do i change the column headings from numbers to letters in ex

how do i change the column headings from numbers to letters in excel?

Michael

how do i change the column headings from numbers to letters in ex

Hi NC. Goto Tools - Options - General Tab and deselect R1C1 reference style.
HTH
--
Sincerely, Michael Colvin

"N C" wrote:

how do i change the column headings from numbers to letters in excel?

All times are GMT +1. The time now is 08:49 AM.