how to change column of letters?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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??
 
You can change to numbers but you can't change the names. However, you can
hide(tools>options>view) and use the top row to put in names as desired but
it is still col B not col "joe"
 
Cannot be done.

Use Row 1 for titles then select A2 and Window>Freeze Panes.

Hide the column and row headers by Tools>Options>View.

Uncheck row and column headers.


Gord Dibben MS Excel MVP
 
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
 
Back
Top