Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do change a column of data in capitol letters to small letters | Excel Discussion (Misc queries) | |||
how do I change column numbers to letters | Excel Discussion (Misc queries) | |||
How can I change column numbers back to column letters? | Excel Worksheet Functions | |||
change column headings letters | Setting up and Configuration of Excel | |||
change column name from letters to numbers? | Excel Discussion (Misc queries) |