98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Column headings in Excel
Column headings in Excel
Resolved · Urgent Priority · Version 2003
Tue 28 Apr 2009, 09:18Delegate Jane said...
Jane has attended:
Excel Intermediate course
Excel Advanced course
Column headings in Excel
A colleague of mine is working on a spreadsheet set up by someone else and when opening the file the column headings are numerical rather than alphabetical. How can we switch this back to alphabetical.
EG currently the cell that is comunly known as A1 is in row 1 and column 1.
This makes understanding the formulae very difficult.
I hope you can help.
Many thanks
Jane Dengate
Tue 28 Apr 2009, 09:28Trainer Rajeev said...
RE: Column headings in Excel
Dear Jane
Thank you for attending Excel Courses!!!! I hope you enjoyed the courses and benefited from them.
1. Please choose Tools > Options from the menu bar.
2. Click on the General Tab
3. In eth settings section Un-tick the R1C1 Reference style.
Press Ok to close the Options dialog box.
I hope this has answered your query.
If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Copying Values Without Formulas in Excel 2010If you want to copy the contents of a cell but don't want to copy the formula with it then use the following simple method: |
