Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 663
Default how to change column of letters?

Hi,

Do the following:

1. On the Tools menu, click Options.
The Options dialog box is displayed.
2. Click the General tab.
3. Select R1C1 reference style check box under Settings
4. Click OK to return to the worksheet. You will notice that the column
header has changed to 123 and so on.

Challa Prabhu

"Madeleiné" wrote:

i want to change the names of the column of letters but i don´t know how just
that it possible

Change A B C and so on

could someone plz help me??

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 change a column of data in capitol letters to small letters Barb P. Excel Discussion (Misc queries) 6 November 15th 06 06:17 PM
how do I change column numbers to letters Marie Excel Discussion (Misc queries) 7 September 15th 06 09:13 AM
How can I change column numbers back to column letters? Space Elf Excel Worksheet Functions 3 March 2nd 06 09:35 PM
change column headings letters Green Goose 89 Setting up and Configuration of Excel 5 February 19th 06 07:53 PM
change column name from letters to numbers? Jerry Excel Discussion (Misc queries) 2 June 28th 05 07:08 PM


All times are GMT +1. The time now is 10:03 AM.

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

About Us

"It's about Microsoft Excel"