Changing column headers from alphabetical characters to numbers?
 

I have inherited a spreadsheet that uses column headings in numbers as well
as the rows. How can I reinstate the column headings to alphabetical
characters?

Changing column headers from alphabetical characters to numbers?
 

Try,

Tools|Options|General
Un-Check R1C1

Mike

"dylan" wrote:

I have inherited a spreadsheet that uses column headings in numbers as well
as the rows. How can I reinstate the column headings to alphabetical
characters?

Changing column headers from alphabetical characters to numbers?
 

ToolsOptionsGeneral Uncheck "R1C1 reference style"


Gord Dibben MS Excel MVP

On Thu, 24 Jul 2008 01:29:02 -0700, dylan
wrote:

I have inherited a spreadsheet that uses column headings in numbers as well
as the rows. How can I reinstate the column headings to alphabetical
characters?