Thread: change column name from 1 2 3 to A B C in Excel 2007
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Curtis[_2_] Dave Curtis[_2_] is offline
external usenet poster
  
Posts: 99
Default change column name from 1 2 3 to A B C in Excel 2007
Hi,

In Excel2003 and earlier, go to ToolsOptionsGeneral and uncheck the R1C1
box.

In Excel2007, you'll have to wait for someone else to comment.

Dave

"Ahmad Sanad" wrote:

Hi All

when I open new Excel file the column name is 1 2 3 and the Row name als 1 2
3 how can I chane back the column name to A B C

Many thanks
Ahmad
Reply With QuoteReply With Quote