ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to change column of letters? (https://www.excelbanter.com/excel-discussion-misc-queries/153107-how-change-column-letters.html)

Madeleiné

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


Don Guillett

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



Gord Dibben

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



challa prabhu

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



All times are GMT +1. The time now is 01:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com