Excel opens up with numbers across the top and down the side ?

When i open a new excel sheet it opens with numbers across the top and down the side, but when i open an existing excel it opens with letters across top and numbers down the side.  Its gotta be a setting we changed by accident but i cant find it.  I tried doing a repair on excel to and restore all the settings, but that didn't work.  
dmccormi35Asked:
Who is Participating?
 
spattewarCommented:
can you tryi going to Tools->Options. General Tab and unchck R1C1 reference style and click OK.
0
 
Bruce PieterseTechnical LeadCommented:
Hi dmccormi35,

Click on Tools > Options > General [Tab] - > Untick RC1C reference style.

Hope that helps.
0
 
dmccormi35Author Commented:
Gotta give more to spattewar, he was first but both were accurate , thanks so much !!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.