How do I change default cell referencing in excel from R1C1 to A1?

H

Hackedoffwith2007

It's driving me nuts - it should be so simple and yet it's impossible to find
out from the help section. All I want to do is change my default settings
back to the way Excel used to have them so the columns are referenced by
letters instead of numbers (eg A1 not R1C1).

I loathe Excel 2007 with a passion - I find it completely unintuitive.
 

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

r1c1 reference style - how to make it default 4
Column headers numbers instead of letters 2
how do i change the column headings from numbers to letters 2
how do I change cell labelling from R1C1 to A1? 2
How do I get Excel column headings to be letters not numbers? 3
How do I change Excel columns from alphabetical to numeric? 6
Procedure to change Column heading from R1C1 to A1? 2
How can I change column titles back to numbers? 4

Top