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

Rod Walters  Identity Verified
Japan
Local time: 22:11
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]


 

Sandra Bertolini  Identity Verified
Italy
Local time: 14:11
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


 

Rod Walters  Identity Verified
Japan
Local time: 22:11
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.


 


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






BaccS – Business Accounting Software
Modern desktop project management for freelance translators

BaccS makes it easy for translators to manage their projects, schedule tasks, create invoices, and view highly customizable reports. User-friendly, ProZ.com integration, community-driven development – a few reasons BaccS is trusted by translators!

More info »
Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »



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