| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change the column designation from a numeric to an alpha
On my version of Excel in Office 2000, the columns are headed in numeric
values, as are the rows. This makes it confusing in entering formulas. Most versions of the spreadsheet have alpha column designations and numeric row designations. How can I change it to have columns headed by alpha charcters and rows by numeric designations? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change the column designation from a numeric to an alpha
toolsoptionsgeneralsettingsr1c1 uncheck
-- Don Guillett SalesAid Software "George Sladky" <George wrote in message ... On my version of Excel in Office 2000, the columns are headed in numeric values, as are the rows. This makes it confusing in entering formulas. Most versions of the spreadsheet have alpha column designations and numeric row designations. How can I change it to have columns headed by alpha charcters and rows by numeric designations? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change the column designation from a numeric to an alpha
Goto ToolsOptionsGeneral and uncheck the R1C1 reference style checkbox.
-- HTH Bob Phillips (remove xxx from email address if mailing direct) "George Sladky" <George wrote in message ... On my version of Excel in Office 2000, the columns are headed in numeric values, as are the rows. This makes it confusing in entering formulas. Most versions of the spreadsheet have alpha column designations and numeric row designations. How can I change it to have columns headed by alpha charcters and rows by numeric designations? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I format a column in alpha order? | New Users to Excel | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| How to change column letters to correct ones in many formulas automatically? | Links and Linking in Excel | |||
| Change the width of a single column in a column chart | Charts and Charting in Excel | |||
Linear Mode
