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