| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing column headers from alphabetical characters to numbers?
I have inherited a spreadsheet that uses column headings in numbers as well
as the rows. How can I reinstate the column headings to alphabetical characters? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing column headers from alphabetical characters to numbers?
Try,
Tools|Options|General Un-Check R1C1 Mike "dylan" wrote: I have inherited a spreadsheet that uses column headings in numbers as well as the rows. How can I reinstate the column headings to alphabetical characters? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing column headers from alphabetical characters to numbers?
ToolsOptionsGeneral Uncheck "R1C1 reference style"
Gord Dibben MS Excel MVP On Thu, 24 Jul 2008 01:29:02 -0700, dylan wrote: I have inherited a spreadsheet that uses column headings in numbers as well as the rows. How can I reinstate the column headings to alphabetical characters? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing the headers on an excel worksheet from Numbers back to le | Excel Worksheet Functions | |||
| How do I get my column headers to go back to alphabetical? | Excel Discussion (Misc queries) | |||
| Changing the Column Headers back to letters from #s | Excel Discussion (Misc queries) | |||
| How do I make Excel column headers alphabetical... | Excel Discussion (Misc queries) | |||
| CHANGING THE COLUMN HEADERS FROM ABC.. TO 123.. | Excel Discussion (Misc queries) | |||
Linear Mode
