How to switch column headers from numbers back to letters?

G

Guest

The column headers are displaying numbers (1,2,3) instead of letters (A,B,C),
which is making it difficult for me to type in formulas. Ultimately, I'd
like to have a column at the right end of my spreadsheet that totals a
specific set of columns *within each row*. How do I do this?

I am using Excel that came with Microsoft Windows XP
 
J

JE McGimpsey

Tools/Options/General, uncheck the R1C1 Reference Style checkbox.

"Measurement Consultant" <Measurement
 
G

Guest

1) Under Tools > Options, select the Settings tab and uncheck the 'R1C1
reference style'.
2) In the first row where you want the totals, enter a formula, something
like =a2+c2+e2 or =sum(a2:f2), whichever more easily specifies the columns
you want added. Autofill that formula into subsequent rows.
 

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

How do I change my column headers? 1
excluding column headers from formulas 3
How to Change Column Header from numbers back to letters 2
Excel sheet with numbers as column & row headers - How? 3
changing column headers to letters? 4
Column Headers: Numbers instead of letters 3
Showing Letters For Column Headers Rather Thann Numbers ? 1
Columns labeled with numbers not letters 8

Top