Column Headings

B

bla50613

I have received a workbook from someone where the column headings (the actual
A.B.C...) is all numbers. Just like the rows. How was that done and how can
I undo it?

Thanks!
 
R

Rick Rothstein \(MVP - VB\)

I have received a workbook from someone where the column headings (the
actual
A.B.C...) is all numbers. Just like the rows. How was that done and how
can
I undo it?
Click to expand...

Tools/Options from Excel's menu bar, click the General tab on the dialog box
that appears, uncheck the "R1C1 reference style" check box under the
Settings area.

Rick
 
G

Gord Dibben

Tools>Options>General

Uncheck R1C1 reference style.


Gord Dibben MS Excel MVP
 
Top