ExcelBanter - My columns now have numbers instead of leters, how do I change thi

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

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

- - My columns now have numbers instead of leters, how do I change thi (https://www.excelbanter.com/excel-discussion-misc-queries/211077-my-columns-now-have-numbers-instead-leters-how-do-i-change-thi.html)

Patscart

My columns now have numbers instead of leters, how do I change thi

I have just opened Excel and on all my spreadsheets the columns no longer
have letters they have numbers, how can I change this back?

Sanjay

My columns now have numbers instead of leters, how do I change thi

Hi Pastsart,
do you mean row header, if yes then go to tool menu click on view and then
select
row&colume headers and then press OK.

Sanjay

"Patscart" wrote:

I have just opened Excel and on all my spreadsheets the columns no longer
have letters they have numbers, how can I change this back?

Gary''s Student

My columns now have numbers instead of leters, how do I change thi

Tools Options General clear the R1C1 style checkbox
--
Gary''s Student - gsnu200815

"Patscart" wrote:

I have just opened Excel and on all my spreadsheets the columns no longer
have letters they have numbers, how can I change this back?

Bob I

My columns now have numbers instead of leters, how do I changethi

In Options uncheck R1C1 reference style.

Patscart wrote:

I have just opened Excel and on all my spreadsheets the columns no longer
have letters they have numbers, how can I change this back?

All times are GMT +1. The time now is 08:56 PM.