#1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 1
Default Excel columns

When i open excel Sheet the columns instead of having alphabets like
(A,B,C,D.... ) it has numbers 1,2,3,4...... . How should i change the
columns numbers to alphbets

  #2   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 22,906
Default Excel columns

Office ButtonExcel OptionsFormulas.

Uncheck R1C1 reference style.


Gord Dibben MS Excel MVP

On Fri, 26 Jun 2009 01:05:02 -0700, Excel 2007 columns <Excel 2007
wrote:

When i open excel Sheet the columns instead of having alphabets like
(A,B,C,D.... ) it has numbers 1,2,3,4...... . How should i change the
columns numbers to alphbets


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
putting 2 long columns into multiple columns in excel page and sor bob_mhc Excel Discussion (Misc queries) 1 April 25th 08 07:51 AM
Excel 2003 - change columns to rows and rows to columns Trish Excel Discussion (Misc queries) 0 August 17th 07 02:22 AM
Excel 2003 - change columns to rows and rows to columns JLatham Excel Discussion (Misc queries) 0 August 17th 07 02:05 AM
"Text to Columns" for many columns in Excel 2003 NickName Excel Discussion (Misc queries) 12 September 8th 06 10:14 PM
unable to insert columns in excel, insert- columns (disabled) iam_leearner Excel Discussion (Misc queries) 1 August 13th 06 02:26 PM


All times are GMT +1. The time now is 11:22 PM.

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"