Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column headings to numbers and row headings to alphabets?
Hi there,
My spreadsheet has gone crazy and now the column headings are in numbers instead of alphabets and at the same time, the row headings are in alphabets instead of numbers. Can anyone advice on how to rectify this? J |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column headings to numbers and row headings to alphabets?
Try
Tools|Options|general tab un-check R1C1 Mike "Juliana" wrote: Hi there, My spreadsheet has gone crazy and now the column headings are in numbers instead of alphabets and at the same time, the row headings are in alphabets instead of numbers. Can anyone advice on how to rectify this? J |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column headings to numbers and row headings to alphabets?
Have another look at the sheet.
You may have numbers for column headers but I doubt if you have letters for row headers. To change the column numbers back to letters go to ToolsOptionsGeneral and uncheck R1C1 Reference Style Gord Dibben MS Excel MVP On Fri, 9 May 2008 01:12:01 -0700, Juliana wrote: Hi there, My spreadsheet has gone crazy and now the column headings are in numbers instead of alphabets and at the same time, the row headings are in alphabets instead of numbers. Can anyone advice on how to rectify this? J |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why are column headings numbers instead of letters? | Excel Discussion (Misc queries) | |||
my column headings are numbers instead of letters.how do i fix | Excel Discussion (Misc queries) | |||
Column Headings are numbers | New Users to Excel | |||
Can I invert a table so row headings are now column headings etc | Excel Worksheet Functions | |||
column headings display as numbers | Setting up and Configuration of Excel |