Column Headings
 

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!
--
PLB

Column Headings
 

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?

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

Column Headings
 

Many thanks!!! You made me the hero of the day!
--
PLB


"Rick Rothstein (MVP - VB)" wrote:

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?

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

Column Headings
 

Tools Options General Uncheck R1C1 OK

HTH
Regards,
Howard

"bla50613" wrote in message
...
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!
--
PLB

Column Headings
 

ToolsOptionsGeneral

Uncheck R1C1 reference style.


Gord Dibben MS Excel MVP

On Fri, 5 Oct 2007 12:27:00 -0700, bla50613 wrote:

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!