Mobile menu

Excel problem - both columns and row names are numbers
Thread poster: Rod Walters

Rod Walters  Identity Verified
Japan
Local time: 08:46
Japanese to English
Feb 19, 2009

I'm using Excel 2002.

I've just noticed that, rather than the usual A B C for columns, they've turned to numbers 1 2 3.
This makes it impossible to write formulae.

I've poked about the menus, the help, and the MS site, but I can't find out how to get them back to normal.

Does anybody know?

Thanks

Edit
OK, I've sorted this out by opening a different file with A B C formulae in it. But I'm still curious to know what caused this in the first place, and how to reset it the 'normal' way.

[Edited at 2009-02-19 07:15 GMT]


Direct link Reply with quote
 

Sandra Bertolini  Identity Verified
Italy
Local time: 00:46
Member (2006)
German to Italian
+ ...
How to go back to letters Feb 19, 2009

Hi Rod,

I used these indications and I think they're useful. Perhaps this is what you need.

http://www.contextures.com/xlfaqApp.html#HeaderNumber

Have a nice day!

Sandra


Direct link Reply with quote
 

Rod Walters  Identity Verified
Japan
Local time: 08:46
Japanese to English
TOPIC STARTER
All sorted now! Feb 19, 2009

Sandra, thank you very much!

I've bookmarked that as a very helpful reference for the future.


Direct link Reply with quote
 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

Excel problem - both columns and row names are numbers

Advanced search






PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

More info »
CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use SDL Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

More info »



All of ProZ.com
  • All of ProZ.com
  • Term search
  • Jobs