change column headings letters

G

Green Goose 89

The column headeing in Excel have somwhow changed to numbers (the rows are
still numbers). How do i change them back to letters?
 
N

Nick Hodge

Green Goose

Tools>Options....>General, uncheck R1C1 reference style

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
G

Gord Dibben

Tools>Options>General.

Uncheck "R1C1 reference style".


Gord Dibben Excel MVP

On Tue, 1 Feb 2005 13:43:01 -0800, "Green Goose 89" <Green Goose
 
G

Green Goose 89

THANK YOU!!!

That was driving me nuts!

Gord Dibben said:
Tools>Options>General.

Uncheck "R1C1 reference style".


Gord Dibben Excel MVP

On Tue, 1 Feb 2005 13:43:01 -0800, "Green Goose 89" <Green Goose
Click to expand...
 
G

Green Goose 89

THANK YOU!!!!

That was driving me nuts!

Nick Hodge said:
Green Goose

Tools>Options....>General, uncheck R1C1 reference style

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
Click to expand...
 
S

sorbet

In my case I came across a column heading in Excel having somewhow
having Beta(Greek?)letters instead of the usual ABC. How do I change
them back to regular letters?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert name and adress from a list in a word document 1
Merging from an Excel file with graphics 1
Help With Typing Russian Letters On Microsoft Word Mac 0
Need help modifying code 0
Inconsistent formatting of section numbers 0
Mail Merge Directory Conditional Page Break 0
White space above heading inconsistently applied 1
Grouping {MERGEFIELD} into 2 or 3 Columns 0

Top