excel spreadsheet question

August 23, 2010 at 16:17:42
Specs: Windows XP
My excel spreadsheet has numbers instead of letters in the column headings. How do I change it back to letters in Excel 2007?

See More: excel spreadsheet question

August 24, 2010 at 03:51:33

Click the Office button and click the 'Excel Options' button at the bottom of the Button 'window'.
In Excel options, select the 'Formulas' tab from the list on the left.
In the section 'Working with Formulas' clear the check box alongside 'R1C1' reference style.
Click OK.

PS you haven't said if there was anything you did just before this change happened. Perhaps you have loaded an Add-In, or opened a Workbook from someone else or the Internet that contained a macro. Either of these could have made changes to your setup.

Report •
Related Solutions

Ask Question