Column headings

The UK's most regular instructor-led training courses.
Training information: excel consultant · Excel courses · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Urgent Priority · Version 2003

4 posts

ReplyFri 15 Jan 2010, 14:05Delegate 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

Version	Date	Location	Places available	Book	Next place rate (£)
Excel VBA Intro Intermediate 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Mon 22 + Tue 23 Mar 2010	Bloomsbury	0	FULL
2007	Tue 6 + Wed 7 Apr 2010	Bloomsbury	4		£470	£475
2003	Wed 7 + Thu 8 Apr 2010	Southwark	7		£445	£450
2007	Thu 15 + Fri 16 Apr 2010	Bloomsbury	0	FULL
2003	Wed 21 + Thu 22 Apr 2010	Bloomsbury	7		£445	£450
2007	Wed 28 + Thu 29 Apr 2010	Bloomsbury	6		£445	£450
Full Schedule: See all 35 Excel VBA Intro Intermediate course dates. Bookings currently available until 22nd December 2010.

1,056 posts

ReplyFri 15 Jan 2010, 16:17Trainer 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.

· How to start using Excel 2007 Functions
· Organisation At Your Fingertips - Take Control Of Your Life With Excel
· Using Excel In Any Condition
· Microsoft Excel Training - Numerical excellence for all
· How to check for and reduce errors in Microsoft Excel

Please browse our web site to find out more about
excel consultant and other Microsoft training courses.

Excel tip:

Shortcut for deleting all comments in a spreadsheet

If you have entered multiple comments into a spreadsheet and wish to delete them all at once, you can achieve this by:

1. Holding down Ctrl, then Shift, then O - this will select all cells containing comments in the worksheet you are looking at.

2. Right-clicking on one of the selected cells, and selecting Delete Comment from the menu that appears.

3. Clicking anywhere else in the spreadsheet to deselect comments - all comments should have disappeared from the spreadsheet.

View all Excel hints and tips