| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does my Excel shows the rows and the columns as numbers?
The row references are number and, usually, the column references are
letters; however, somehow my Excel file was changed and the rows and colums are numbers. How did this happen and/or how do I change it back? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why does my Excel shows the rows and the columns as numbers?
Toolsoptionsgeneral remove checkmark from R1C1 reference style
-- Regards, Peo Sjoblom "Coulum/Row Reference" <Coulum/Row wrote in message ... The row references are number and, usually, the column references are letters; however, somehow my Excel file was changed and the rows and colums are numbers. How did this happen and/or how do I change it back? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why does my Excel shows the rows and the columns as numbers?
Hi Peo
Most replies in newsgroups seem to -& most often correctly- assume that the OP is not using Excel 2007? Is there any explanation to this? Best wishes Harald "Peo Sjoblom" skrev i melding ... Toolsoptionsgeneral remove checkmark from R1C1 reference style -- Regards, Peo Sjoblom "Coulum/Row Reference" <Coulum/Row wrote in message ... The row references are number and, usually, the column references are letters; however, somehow my Excel file was changed and the rows and colums are numbers. How did this happen and/or how do I change it back? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why does my Excel shows the rows and the columns as numbers?
Hi Harald,
I just assumed Plus of course unless this is the OP's first Excel experience most users mention that they use 2007 if that's the case. -- Regards, Peo Sjoblom "Harald Staff" wrote in message ... Hi Peo Most replies in newsgroups seem to -& most often correctly- assume that the OP is not using Excel 2007? Is there any explanation to this? Best wishes Harald "Peo Sjoblom" skrev i melding ... Toolsoptionsgeneral remove checkmark from R1C1 reference style -- Regards, Peo Sjoblom "Coulum/Row Reference" <Coulum/Row wrote in message ... The row references are number and, usually, the column references are letters; however, somehow my Excel file was changed and the rows and colums are numbers. How did this happen and/or how do I change it back? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why does my Excel shows the rows and the columns as numbers?
Most experienced Excel users have not changed to 2007.
Newcomers to Excel are often satisfied with 2007, but those accustomed to using 2003 prefer it over 2007. The main concerns are the replacement of menus by the ribbon, and some degradation in charting functionality. Natrurally the extended limits, such as on number of rows, number of columns, and nesting depth, are an advantage in 2007. -- David Biddulph "Harald Staff" wrote in message ... Hi Peo Most replies in newsgroups seem to -& most often correctly- assume that the OP is not using Excel 2007? Is there any explanation to this? "Peo Sjoblom" skrev i melding ... Toolsoptionsgeneral remove checkmark from R1C1 reference style "Coulum/Row Reference" <Coulum/Row wrote in message ... The row references are number and, usually, the column references are letters; however, somehow my Excel file was changed and the rows and colums are numbers. How did this happen and/or how do I change it back? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why does my Excel shows the rows and the columns as numbers?
Tools Options on the General tab, uncheck the R1C1 reference style box
click OK Hope this helps, Hutch "Coulum/Row Reference" wrote: The row references are number and, usually, the column references are letters; however, somehow my Excel file was changed and the rows and colums are numbers. How did this happen and/or how do I change it back? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Having trouble inputting numbers past 09 it shows 0.10 in excel | Excel Discussion (Misc queries) | |||
| Excel is showing numbers as headers for both rows and columns?? | Setting up and Configuration of Excel | |||
| How do I set rows to Alpha and columns to numbers? | Setting up and Configuration of Excel | |||
| How do I sort numbers in a table (ie. rows & columns)? | Excel Discussion (Misc queries) | |||
| rows and columns as numbers | Setting up and Configuration of Excel | |||
Hybrid Mode
