Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel course - Excel

microsoft excel course - Excel

ResolvedVersion Standard

Thu 5 Jul 2007, 08:53 Delegate Daryl said...

Daryl has attended:
Excel Advanced course

Excel

Hi

My column headings in excel 2003 have changed from letters to numbers so I now have numbers for rows and columns.

#I do not know how I have managed to do this nor how to change back to the normal A, B, C etc column headings

Please advise

Regards
Daryl

Thu 5 Jul 2007, 08:58 Delegate Andrew said...

RE: Excel

Daryl:

Tools...options....general tab.....uncheck the R1C1 box....OK

Good luck!

Andy

Thu 5 Jul 2007, 09:00 Delegate Daryl said...

RE: Excel

Many thanks - I can stop pulling my hair out now !!!

Fri 31 Aug 2007, 13:23 Trainer David said...

RE: Excel

tools options general - remove tick from r1c1 style

Training courses

98.6 % recommend us

More live stats...

Training information:

Excel tip:

Wrapping Text in a Cell in an Excel 2010 Workbook

When you have a lot of text you want to put in a particular cell but you can't decrease the font size to fit because the text will then become ineligible, then manually wrap the text in a cell by simply pressing ALT+ENTER.

View all Excel hints and tips

microsoft excel course - Excel

Excel

RE: Excel

RE: Excel

RE: Excel

Excel articles

Excel tip:

Wrapping Text in a Cell in an Excel 2010 Workbook