ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel Colum and Rows Problem (https://www.excelbanter.com/excel-programming/383550-excel-colum-rows-problem.html)

Abid[_2_]

Excel Colum and Rows Problem
 
Hi,

my excel screen has changed like to (numbers) all rows and colums as
follow :

1 2 3 4 5
2
3
4

But on defalt it should be like this

1 A B C D E F
2
3
4


how can i do that ???

plz advice
thanks in advance


JE McGimpsey

Excel Colum and Rows Problem
 
Tools/Option/General, uncheck R1C1 reference style checkbox.

In article .com,
"Abid" wrote:

Hi,

my excel screen has changed like to (numbers) all rows and colums as
follow :

1 2 3 4 5
2
3
4

But on defalt it should be like this

1 A B C D E F
2
3
4


how can i do that ???

plz advice
thanks in advance


Nick Hodge

Excel Colum and Rows Problem
 
Abid

ToolsOptionsGeneral and un-check R1C1 references

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Abid" wrote in message
oups.com...
Hi,

my excel screen has changed like to (numbers) all rows and colums as
follow :

1 2 3 4 5
2
3
4

But on defalt it should be like this

1 A B C D E F
2
3
4


how can i do that ???

plz advice
thanks in advance




All times are GMT +1. The time now is 10:29 AM.

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