Thu 23 Jul 2009, 11:57Delegate Linda said...
Linda has attended:
Excel Advanced course
Excel column numbering
When doing my recent course I noticed that one of the spreadsheets had numbered columns (rather than lettered) - how can I change mine to show numbering?
Thu 23 Jul 2009, 13:07Trainer Amanda said...
RE: Excel column numbering
Hello Linda
Thank you for your question.
You can display numbers instead of letters at the top of your columns by changing Excel to 'R1C1 reference style'. This will also change how the cells in your spreadsheet are referred to as well, e.g. cell A1 becomes R1C1.
To change to R1C1 reference style, go to Tools - Options - General tab, and tick R1C1 reference style. Click OK.
Kind regards
Amanda
