| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Headings of columns now have numbers, need to change them to lette
Today all the headings of my columns of my spread sheets have changed to
numbers. Can someone tell me how to change them back to letters? I'm using office 2007. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Headings of columns now have numbers, need to change them to lette
1. Click the Office button and then click on Excel Options.
2. At the left side click Formulas. 3. clear the R1C1 Reference Style check box 4. Click on OK.-- "JeffL" wrote: Today all the headings of my columns of my spread sheets have changed to numbers. Can someone tell me how to change them back to letters? I'm using office 2007. Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Headings of columns now have numbers, need to change them to lette
go to Tool Options
In General tab Settings uncheck R1C1 reference style -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "JeffL" wrote: Today all the headings of my columns of my spread sheets have changed to numbers. Can someone tell me how to change them back to letters? I'm using office 2007. Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Headings of columns now have numbers, need to change them to lette
Didn't the OP say 2007?
-- David Biddulph "Francis" <xlsmateATgmailDOTcom wrote in message ... go to Tool Options In General tab Settings uncheck R1C1 reference style -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "JeffL" wrote: Today all the headings of my columns of my spread sheets have changed to numbers. Can someone tell me how to change them back to letters? I'm using office 2007. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Columns headings changed to numbers in all of my worksheets | New Users to Excel | |||
| I want to get rid of columns with numbers as headings, how do I? | Excel Discussion (Misc queries) | |||
| How do columns headings change from letters to numbers? | Excel Discussion (Misc queries) | |||
| How do I change headings for columns from numbers to letters? | Excel Discussion (Misc queries) | |||
| How do I change headings for columns from numbers to letters? | Excel Discussion (Misc queries) | |||
Linear Mode
