| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change numbered columns to letters?
My Excel spread sheets used to have letters across the top adn numbers down
the left side. Now there are numbers both across the top and down the left side. How can I get back to the lettered columns? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to change numbered columns to letters?
Tools Options General clear the R1C1 reference checkbox.
-- Gary''s Student - gsnu200818 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to change numbered columns to letters?
With XL2003 or earlier, click on Tools | Options | General tab,
unclick R1C1 reference style, then click OK. Hope this helps. Pete On Dec 6, 12:17*am, anwillia wrote: My Excel spread sheets used to have letters across the top adn numbers down the left side. *Now there are numbers both across the top and down the left side. *How can I get back to the lettered columns? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to change numbered columns to letters?
Perfect -- thanks for such a quick and concise reply.
"Gary''s Student" wrote: Tools Options General clear the R1C1 reference checkbox. -- Gary''s Student - gsnu200818 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Columns change from letters to numbers | Excel Discussion (Misc queries) | |||
| How do I change the Excel columns back to letters? | Excel Discussion (Misc queries) | |||
| how do I change the columns to letters not numbers | Excel Discussion (Misc queries) | |||
| How do I change numbered columns to alphabet columns? | Excel Discussion (Misc queries) | |||
| Change Columns to Letters | New Users to Excel | |||
Linear Mode
