CAN I CHANGE COLUMN HEADERS FROM LETTERS TO WORDS?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I AM CURRENTLY IN MEDICAL SCHOOL AND TRYING TO CHANGE THE A,B,C... TO
DIFFERENT WORDS. IS THAT POSSIBLE?
 
No.

But you can type in the headings you want in row 1.

Then click on Cell A1 and select Windows/Freeze Pane.

The screen will now scroll below the headings you created.
 
You can change them between 1,2,3,..., A,B,C...., or choose to show nothing.

But I'd leave the letters there, then put those alternate titles in Row 1. (Use
alt-enter to force a new line within the cell).

Then make sure A1 is visible
select A2 and then
Window|freeze panes

So row 1 will always be visible.

(And you may want to use File|page setup|sheet tab|rows to repeat at top when
you print.)
 
No, your only options are to change them to numbers instead of letters
(Tools/Options/General) or to not display them at all (Tools/Options/View).

If you do the former, you must enter all formulas in R1C1 notation. If you do
the latter, I think you'll have great trouble entering your formulas.

Or you can enter new column headers in row 1, then freeze panes (Window menu)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Showing Letters For Column Headers Rather Thann Numbers ? 1
Column Header is not in Letter 1
Office 365 Word - word count 1
How to type each letter of the alphabet automatically in a specific color in Word? 0
Excel coolumn headings changed from A, B, C, etc. to 1, 2, 3 1
Why is my header row numbers instead of letters? 2
Column Headers 1
why are my column headers numbers instead of letters? 2

Back
Top