Forum home » Delegate support and help forum » Microsoft Excel Training and help » Changinfg the row headings (A, B, C, etc) on Excel

Changinfg the row headings (A, B, C, etc) on Excel

ResolvedVersion 2007

Fri 9 Apr 2010, 16:50 Delegate Adrian said...

Adrian has attended:
Excel Intermediate course
Excel Advanced course
Project Intro Intermediate course
Excel Advanced course

Changinfg the row headings (A, B, C, etc) on Excel

Is it possible to name change the Row Headings (A,B,C) into specific names? (eg if showing a sheet for presentatonal purposes on a screen)

Tue 13 Apr 2010, 14:19 Trainer Anthony said...

RE: Changinfg the row headings (A, B, C, etc) on Excel

Hi Adrian, thanks for your query. That's not possible, unfortunately, without completely re-wiring Excel! You can switch on R1C1 notation and see the column headings as numbers by selecting R1C1 notation in the Formulas category of Excel Options, but that's about as a good as it gets.

Hope this helps,

Anthony

Tue 20 Apr 2010: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Turn off AutoComplete in Excel

You may have noticed when typing into your spreadsheets that if you start to enter labels that begin with the same letters as a label that has been previously entered in the same spreadsheet, Excel will try and automatically complete the text for you. This feature is called AutoComplete.

If you find this feature more annoying than useful, you can turn it off by:

1. Going to Tools - Options.

2. Select the Edit tab.

3. Remove the tick from next to the "Enable AutoComplete for cell values" option.

4. Click OK.

View all Excel hints and tips

Changinfg the row headings (A, B, C, etc) on Excel

Changinfg the row headings (A, B, C, etc) on Excel

RE: Changinfg the row headings (A, B, C, etc) on Excel

Excel articles

Excel tip:

Turn off AutoComplete in Excel