Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 3
Default How to change Cell address from numbered column to Alphanumeric

In Excel 2003 it was easy through Options but I am unable In Excel 2007 to
find the way to change the title of the column from 1, 2, 3 etc.. to A, B. C
to AA, Ab, etc..
  #2   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 2,480
Default How to change Cell address from numbered column to Alphanumeric

Hi Ramez

Round Office buttonExcel OptionsFormulaWorking with FormulasR1C1
Reference style

--
Regards
Roger Govier

"Ramez" wrote in message
...
In Excel 2003 it was easy through Options but I am unable In Excel 2007 to
find the way to change the title of the column from 1, 2, 3 etc.. to A, B.
C
to AA, Ab, etc..


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I avoid excel change absolute address to relative address Miguel Excel Discussion (Misc queries) 3 May 10th 07 11:18 PM
create numbered sortable numbered list in excel coloradio Excel Discussion (Misc queries) 2 November 15th 06 06:50 PM
How to determine the column letter from Cell address Jean Excel Worksheet Functions 6 July 24th 06 03:04 AM
If Statment - Active Cell Column Address Richard Excel Discussion (Misc queries) 2 June 9th 06 11:22 PM
My worksheet is numbered in both row and column. Is that right? Sheila Excel Worksheet Functions 1 March 21st 06 07:16 PM


All times are GMT +1. The time now is 01:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"