Mobile menu

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

Rod Walters  Identity Verified
Japan
Local time: 17:45
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: 10:45
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: 17:45
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






Across v6.3
Translation Toolkit and Sales Potential under One Roof

Apart from features that enable you to translate more efficiently, the new Across Translator Edition v6.3 comprises your crossMarket membership. The new online network for Across users assists you in exploring new sales potential and generating revenue.

More info »
TM-Town
Manage your TMs and Terms ... and boost your translation business

Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.

More info »



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