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

Column headings

ResolvedVersion 2003

Fri 15 Jan 2010, 14:05 Delegate Kaylea said...

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

Fri 15 Jan 2010, 16:17 Trainer Andrew said...

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

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Navigate with keyboard without losing your active cell

If you like using your keyboard to scroll through your excel document, but want to keep your active cell the same, use the scroll lock, and then use your arrow keys to navigate around the document.

View all Excel hints and tips

Column headings

Column headings

RE: Column headings

Excel articles

Excel tip:

Navigate with keyboard without losing your active cell