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

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??

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,124
Default how to change column of letters?

You can change to numbers but you can't change the names. However, you can
hide(toolsoptionsview) and use the top row to put in names as desired but
it is still col B not col "joe"

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Madeleiné" wrote in message
...
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??


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default how to change column of letters?

Cannot be done.

Use Row 1 for titles then select A2 and WindowFreeze Panes.

Hide the column and row headers by ToolsOptionsView.

Uncheck row and column headers.


Gord Dibben MS Excel MVP

On Mon, 6 Aug 2007 06:00:00 -0700, 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??


  #4   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 01:19 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"