| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Columns now numbers rather than letters how do i get letters back
Somehow I have managed to accidentally change the column references to
numbers rather than letters. How do I get these back? Not sure of the correct terminology but I am referring to where the rows are usually numbers and the columns usually letters. My columns are now also numbers! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Columns now numbers rather than letters how do i get letters back
In EXCEL 2007:-
Office Button (top left hand corner) Excel Options (lower right hand corner) Formulas - make sure that there is no tick in the box called:- R1C1 reference style EXCEL 2003 Tools / Options / General tab €“ remove tick from R1C1 Reference style. If my comments have helped please hit Yes. Thanks. "SalExcel10" wrote: Somehow I have managed to accidentally change the column references to numbers rather than letters. How do I get these back? Not sure of the correct terminology but I am referring to where the rows are usually numbers and the columns usually letters. My columns are now also numbers! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Columns now numbers rather than letters how do i get letters back
toolsoptionsgeneralr1c1
-- Don Guillett Microsoft MVP Excel SalesAid Software "SalExcel10" wrote in message ... Somehow I have managed to accidentally change the column references to numbers rather than letters. How do I get these back? Not sure of the correct terminology but I am referring to where the rows are usually numbers and the columns usually letters. My columns are now also numbers! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Column chngd fm letters to numbers. What that & how do I go back? | Excel Discussion (Misc queries) | |||
| Column chngd fm letters to numbers. What that & how do I go back? | Excel Discussion (Misc queries) | |||
| all my top rows are now numbers, how to set it back to letters | Excel Discussion (Misc queries) | |||
| Columns are numbers, rows letters. How do I change back? | Setting up and Configuration of Excel | |||
| Columns are numbers, rows letters. How do I change back? | Setting up and Configuration of Excel | |||
Linear Mode
