Excel (rows)

  Noldi 10:29 06 Mar 06
Locked

Could somebody jog my memory please?
I have a new work computer and I can’t remember how to set up Excel so that rows are list ABC etc not 123.
Regards Noldi

  Noldi 10:38 06 Mar 06

Sorry forgot to mention Office 2000 premium

  Eric10 11:31 06 Mar 06

If you mean that you have 1 2 3 etc along the top (columns) instead of A B C then you need to uncheck 'R1C1 reference style' under Tools, Options, General tab. If this is what you need then I must give credit to VoG™ as this was learned from his answer to a previous similar enquiry.

  Noldi 12:40 06 Mar 06

Thanks for that Erich (I meant Columns must Monday brain fade)
Regards Noldi

  GroupFC 13:12 06 Mar 06

Doh!! - if you had said columns I knew the answer (of course learnt from the excel guru!) - I was busily looking at the Excel help files when Eric10 posted!

This thread is now locked and can not be replied to.

Sniper Elite 4 review: Headshotting Nazis has never felt so good

1995-2015: How technology has changed the world in 20 years

The Best Design, Illustration, Animation and VFX Awards of 2017

WWDC 2017 dates: How to get WWDC 2017 tickets, when is WWDC 2017 and more details announced