| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
column names - chane from numbrts back to A- z
Another user of an excel sheet I created has changed the column names from
the alphabetic ones to numbers making the transfer of cells by thier ref. difficultt . Instead of reading ref A1 for example it shows R1C1. Any ideas how i can change it back - have searched help with no success |
|
#2
|
|||
|
|||
|
Go into Tools/Options/General and uncheck the R1C1 reference style box
Best rgds Chris Lav "genie" wrote in message ... Another user of an excel sheet I created has changed the column names from the alphabetic ones to numbers making the transfer of cells by thier ref. difficultt . Instead of reading ref A1 for example it shows R1C1. Any ideas how i can change it back - have searched help with no success |
|
#3
|
|||
|
|||
|
Hi, Maybe TOOLS/OPTIONS/GENERAL tab and uncheck R1C1 reference style HTH JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=475639 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Column Names | Excel Discussion (Misc queries) | |||
| Changed column width keeps reverting back to original size | Excel Discussion (Misc queries) | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| Column A is Town, Column B is names. How can Excel add & tell how. | Charts and Charting in Excel | |||
| how can I change the a,b,c, column headers in excel to names | Excel Discussion (Misc queries) | |||
Linear Mode
