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

Rod Walters  Identity Verified
Japan
Local time: 09:38
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: 02:38
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: 09:38
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 »
WordFinder
The words you want Anywhere, Anytime

WordFinder is the market's fastest and easiest way of finding the right word, term, translation or synonym in one or more dictionaries. In our assortment you can choose among more than 120 dictionaries in 15 languages from leading publishers.

More info »



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