| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
alpha column changed to numerical column
I don't know what happened. I had a spreadsheet with columns A,B,C..... and
all of a sudden it's showing up with columns 1,2,3,..... It still has rows 1,2,3,.... Does anyone know how I can get the columns A,B,C.....back? MSOffice XP is being used on a WinXP system -- Thanks, Diane |
|
#2
|
|||
|
|||
|
alpha column changed to numerical column
Hi Diane
ToolsOptionsGeneraluntick the R1C1 box Regards Roger Govier DianeMcP wrote: I don't know what happened. I had a spreadsheet with columns A,B,C..... and all of a sudden it's showing up with columns 1,2,3,..... It still has rows 1,2,3,.... Does anyone know how I can get the columns A,B,C.....back? MSOffice XP is being used on a WinXP system |
|
#3
|
|||
|
|||
|
alpha column changed to numerical column
Never mind.... I found the setting under Tools, Options, General which
referenced the "R1C1 reference style" - which somehow got checked..... unchecked it..... -- Thanks, Diane "DianeMcP" wrote: I don't know what happened. I had a spreadsheet with columns A,B,C..... and all of a sudden it's showing up with columns 1,2,3,..... It still has rows 1,2,3,.... Does anyone know how I can get the columns A,B,C.....back? MSOffice XP is being used on a WinXP system -- Thanks, Diane |
|
#4
|
|||
|
|||
|
alpha column changed to numerical column
DianeMcP
Tools Options General tab Uncheck 'R1C1 reference style. George Gee DianeMcP wrote: I don't know what happened. I had a spreadsheet with columns A,B,C..... and all of a sudden it's showing up with columns 1,2,3,..... It still has rows 1,2,3,.... Does anyone know how I can get the columns A,B,C.....back? MSOffice XP is being used on a WinXP system |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return Numerical Label for LAST value Subtracted to reach Sum Target Value | Excel Worksheet Functions | |||
| Lookup Table Dilemma | Excel Worksheet Functions | |||
| How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
| up to 7 functions? | Excel Worksheet Functions | |||
| In Excel, COLUMN HEADERS ARE NUMERICAL | Excel Discussion (Misc queries) | |||
Linear Mode
