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

[Guest]

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/com...d-e56c8c20180f&dg=microsoft.public.excel.misc

 

[Chip Pearson]

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


in message
news:[email protected]...