ExcelBanter - Renaming a column or heading?

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Renaming a column or heading? (https://www.excelbanter.com/excel-worksheet-functions/9729-renaming-column-heading.html)

notanexpertinexcel

Renaming a column or heading?

My husband and I work together.
He somehow changed the COLUMN heading to 1,2,3,4, 5... from A,B,C,D..
he cannot figure out how to change back. I see from the posts that it's not
possible, but he must have done something to change this?
Ideas?

Gord Dibben

ToolsOptionsGeneral

Uncheck "R1C1 reference style"

Gord Dibben Excel MVP

On Mon, 24 Jan 2005 17:11:03 -0800, notanexpertinexcel
wrote:

My husband and I work together.
He somehow changed the COLUMN heading to 1,2,3,4, 5... from A,B,C,D..
he cannot figure out how to change back. I see from the posts that it's not
possible, but he must have done something to change this?
Ideas?

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