Columns with # designation

S

swynne

Our company has an Excel document that appears to have been formatted for
excel from something else. The rows and columns both have numbers. If you
open this document all new documents you make have # for rows and columns
until you open an old document that has letters and numbers, then everything
is great.

What is up with this?
 
D

Dave Peterson

Tools|Options|General Tab
Uncheck R1C1 Reference style.

Excel will pick up this setting from the first workbook you open in that session
of excel.
 
N

Niek Otten

This is an Excel-wide setting, which means it is applied to all open
workbooks in that instance of Excel.
You can change it (again, for all open workbooks):

Tools>Options>General, uncheck R1C1 Reference style
 
Top