| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change Excel columns from alphabetical to numeric?
I have Office 2007 and want to use R1C1 reference not A1. There is a
reference to R1C1 in a Help topic but no mention of how to get to it. I have old files which I want to remain R1C1 because of the convenience of counting columns to duplicate. For instance, copying a function in column 6 to ten additional columns takes it to column 16. Copying it from column E takes it to column O, not very intuitive. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i change the heading of excel columns to alphabetical | Excel Discussion (Misc queries) | |||
| numeric sort on one sheet, automatically sorts alphabetical on another? | Excel Discussion (Misc queries) | |||
| change excel column headings from numeric to alphabetical | Excel Discussion (Misc queries) | |||
| HOW DO I CHANGE COLUMNS FROM NUMERIC TO ALPHA HEADINGS? | Excel Discussion (Misc queries) | |||
| Columns are now numeric, not alpha. how to change back? | Excel Discussion (Misc queries) | |||
Threaded Mode
