03Excel shldn't chg col hdrs to nos after text to col, keep alpha
 

2003 EXCEL: After using text-to-columns, column headers change to numbers,
the same as the rows. Afterwards, it's difficult to create formulas to work
with in the spread sheets, especially when you want to use absolute
references. I looked through help but found no relief. The only way I could
figure out how to change them back is to close the workbook, open a previous
workbook that has alpha across the top, and then reopen the problem workbook.
Excel adopts the first spread sheet's view and carries it over to the
problem workbook. Save it then. If anyone else knows a keyboard shortcut or
better way to revert to the alpha headers for columns, please let me know!!
Thanks!

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

I've never seen the behavior that you describe, but you can reset
the column headers back to letters. Go to the Tools menu, choose
Options, then the General tab. There, uncheck the "R1C1 reference
style" setting.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"sohightenor74" wrote
in message
...
2003 EXCEL: After using text-to-columns, column headers change
to numbers,
the same as the rows. Afterwards, it's difficult to create
formulas to work
with in the spread sheets, especially when you want to use
absolute
references. I looked through help but found no relief. The
only way I could
figure out how to change them back is to close the workbook,
open a previous
workbook that has alpha across the top, and then reopen the
problem workbook.
Excel adopts the first spread sheet's view and carries it over
to the
problem workbook. Save it then. If anyone else knows a
keyboard shortcut or
better way to revert to the alpha headers for columns, please
let me know!!
Thanks!

----------------
This post is a suggestion for Microsoft, and Microsoft responds
to the
suggestions with the most votes. To vote for this suggestion,
click the "I
Agree" button in the message pane. If you do not see the
button, follow this
link to open the suggestion in the Microsoft Web-based
Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc