changinfg row headings a

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

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

resolvedResolved · Medium Priority · Version 2007

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)

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

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Line breaks in a cell

You can control the line breaks for multiple-line headings or labels in your Microsoft Excel worksheet, just like you do in Microsoft Word. Here's how to do it.

Click the cell where you want the label or heading to appear.
Type the first line of information.
Press ALT+ENTER.

View all Excel hints and tips


Server loaded in 0.09 secs.