How can I use Lotus 123 comands?; can I format Excel to do so?

E

Edward

How can I use Lotus 123 comands?; can I format Excel to do so?

I was able to use the 'transition' app when I was using Excel 2000, but I
would like to continue to use the Lotus 1-2-3 commands,, formulas, etc. while
using Excel 2007 and the Beta version of Excel 2010...

Please help as soon as possible...

Thank you very much...
 
G

Gord Dibben

Still available in 2007..........don't know about 2010

Button>Excel Options>Advanced.

Scroll to bottom of page.


Gord Dibben MS Excel MVP
 
E

Edward

....thank you ever so much Gord Dibben...

....the only thing is what boxes do I 'check'?... (they have three (3) boxers
in all: 1.) Transition Navigation Keys, 2.) Transition Formula Evaluation,
and 3.) Transition Formula Entry)...

....I would just like to use the 'slash' {/} key, and in the past, when I'd
use Excel 2000, one I hit the / key, than my various Menus would appear, for
example:
/ (which would bring up a Menu, and then if I hit 'F', the 'F' would
represent 'File', and if I then hit 'R', the 'R' would represent 'Retrieve',
therefore /FR would be 'Menu', 'File', 'Retrieve' in Lotus 1-2-3 language and
'/DSR' would be be 'Menu', 'Data', 'Sort', 'Range', etc., etc.

....could you (or anyone else) help me futher here?...

....again, thank you very much...

....I greatly appreciate it!...
 
G

Gord Dibben

Above those 3 transition options is a dialog for Microsoft Excel Menu Key.

Enter the slash key in that dialog.

Now when on a sheet hit the / and you will see a bunch of letters up on the
ribbon and numbers on the QAT

So for File menu you would hit /,F,O for open

Data menu /,A,S for Sort


Gord Dibben
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top