Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Text Wrapping | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |