Column Header Problem

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

Guest

My column headers are 1,2,3,etc. and my row header is A,B,C,etc. If you
think about this - this is the exact opposite of the norm. How do you switch
the column header to A,B,C,etc and the row header to 1,2,3,etc?? Please
help...I can't seem to figure this out. Thanks!!
 
Frank-

Thanks...but no that was not it.....I've also seen where both the row and
column header are both numerical. I would love to know how to fix this also.
Only happened in one spreadsheet - when I open a new it's correct??? Thanks!
 
Hi
if both are numeric goto
'tools - Options - General' and uncheck 'R1C1 Reference Style'
 

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

excluding column headers from formulas 3
Multiple SUM's in a column 15
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Subtracting based on 2 conditions 3
Change color of row and column worksheet headers 2
Change the properties of the worksheet row or column header bars 6
How to switch column headers from numbers back to letters? 2
Return column header based on last value in row 3

Back
Top