PC Review


Reply
Thread Tools Rate Thread

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

 
 
Edward
Guest
Posts: n/a
 
      6th Jan 2010
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...
 
Reply With Quote
 
 
 
 
Gord Dibben
Guest
Posts: n/a
 
      6th Jan 2010
Still available in 2007..........don't know about 2010

Button>Excel Options>Advanced.

Scroll to bottom of page.


Gord Dibben MS Excel MVP

On Wed, 6 Jan 2010 12:51:05 -0800, Edward <(E-Mail Removed)>
wrote:

>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...


 
Reply With Quote
 
Edward
Guest
Posts: n/a
 
      6th Jan 2010
....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!...



"Gord Dibben" wrote:

> Still available in 2007..........don't know about 2010
>
> Button>Excel Options>Advanced.
>
> Scroll to bottom of page.
>
>
> Gord Dibben MS Excel MVP
>
> On Wed, 6 Jan 2010 12:51:05 -0800, Edward <(E-Mail Removed)>
> wrote:
>
> >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...

>
> .
>

 
Reply With Quote
 
Gord Dibben
Guest
Posts: n/a
 
      7th Jan 2010
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

On Wed, 6 Jan 2010 14:59:01 -0800, Edward <(E-Mail Removed)>
wrote:

>...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!...
>
>
>
>"Gord Dibben" wrote:
>
>> Still available in 2007..........don't know about 2010
>>
>> Button>Excel Options>Advanced.
>>
>> Scroll to bottom of page.
>>
>>
>> Gord Dibben MS Excel MVP
>>
>> On Wed, 6 Jan 2010 12:51:05 -0800, Edward <(E-Mail Removed)>
>> wrote:
>>
>> >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...

>>
>> .
>>


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting Lotus 1-2-3 files to Excel 2007 format Clas Microsoft Excel Worksheet Functions 4 18th Apr 2007 05:45 AM
Date format in Lotus 1-2-3 files transferred to Excel 2000 (XP) Willystu Microsoft Excel New Users 1 20th Aug 2004 02:44 PM
Converting Lotus .WK4 files to Excel format Carl Rapson Microsoft Excel Worksheet Functions 4 31st Jul 2003 06:53 AM
Re: Powerpoint format saved to Lotus Freelance format Steve Rindsberg Microsoft Powerpoint 2 26th Jul 2003 08:07 PM
Powerpoint format saved to Lotus Freelance format Jane Microsoft Powerpoint 0 25th Jul 2003 08:25 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:43 PM.