| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IN EXCEL. HOW TO PRINT ONLY ROWS THAT HAVE A VALU IN COLUM A | New Users to Excel | |||
| IN EXCEL. HOW TO PRINT ONLY ROWS THAT HAVE A VALU IN COLUM A | New Users to Excel | |||
| How to regroup rows that have the same value in a particular colum | Excel Discussion (Misc queries) | |||
| On protected Excel sheet users be able to group/ungroup rows/colum | Excel Worksheet Functions | |||
| Print Colum/Rows | Excel Discussion (Misc queries) | |||
![Abid[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
