Add-in or perma fix to add numbers to columns

[ad-venture]

I want to show numbers on the columns instead of letters. I know about the R1C1 option, but I can't get this to stick for all excel sheets. Is there a way to make this default for all sheets and all new sheets, or is there an add-in that can produce this functionality? Thanks.

[Mayda89]

Hi and welcome to the forum,

Yes, R1C1 style should easily be set permanently.
Here's how to do it in Excl2010, I'm not sure if it's the same in Excel2007 but I think it should be very similar.
Click File on the ribbon, go to options
Click Formulas tab, and there you'll find a checkbox saying "use R1C1 reference style".

Cheers,

[ad-venture]

Thanks, yes I've tried this, but for some reason it doesn't save the setting, so when I open a different sheet, it's not using R1C1.

[Mayda89]

Check this out!
http://stackoverflow.com/questions/3...s-to-r1c1-mode

[MrShorty]

I think what happens is that, kind of like calculation option, R1C1/A1 notation option is stored with the workbook. After opening Excel, the first workbook you open will decide whether you are in A1 or R1C1 notation. After you have been using R1C1 notation for a while, most/all of your workbooks will contain the R1C1 toggle, and you won't see this as much.

Try saving a small workbook in R1C1 notation in your Excel startup folder. Then, this will open automatically when you open Excel and should fix the R1C1 notation for you each time you open Excel, until you've been using it long enough to see fewer and fewer problems.