column headings

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Column headings

Column headings

resolvedResolved · Urgent Priority · Version 2003

Kaylea has attended:
Excel Advanced course

Column headings

My column headings have changed from A,B,C,D,E, etc.. to 1,2,3,4,5 etc..

How can I change these back to A,B,C,D,E?

Thank you

RE: Column headings

Hi Kaylea

Thanks for your question. This can be switched back by gont to Tools > Options > General and removing the tick from R1C1 reference style.

I hope this helps - let us know how you get on .

Kind regards,
Andrew

Fri 22 Jan 2010: Automatically marked as resolved.

 

Training courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Quickly Adding New Worksheets

Want to place a new Excel worksheet before current worksheet. Use keystroke SHIFT+F11

View all Excel hints and tips


Server loaded in 0.11 secs.