| Lotus 1-2-3 |
Microsoft Excel |
| F1 (Help) |
F1 |
| F2 (Edit) |
F2 |
| F3 (Name) |
F3 |
| F4 (Absolute/relative) |
F4 |
| F5 (Go to) |
F5 |
| F6 (Next window) |
CTRL+F6 |
| F7 (Query) |
Use the AutoFilter command (Data menu) to find rows in a range or list:
Press ALT, D, F, F to filter the range or list. Use the arrow keys to select the cell that contains the column label, and then press ALT+DOWN ARROW, select a value in the AutoFilter list, and press ENTER.
|
| F8 (Data table) |
Tables recalculate automatically, unless you select the Automatic except tables check box on the Calculation tab (Tools menu, Options command). If this option is set, you can manually recalculate data tables by pressing F9. |
| F9 (Calculate) |
F9 |
| F10 (Graph) |
F11 or ALT+F1 |
Navigation key equivalents
| Lotus 1-2-3 |
Microsoft Excel |
| Up, Down |
UP ARROW, DOWN ARROW |
| Left, Right |
LEFT ARROW, RIGHT ARROW |
| End, Up |
CTRL+UP ARROW or END+UP ARROW |
| End, Down |
CTRL+DOWN ARROW or END+DOWN ARROW |
| End, Left |
CTRL+LEFT ARROW or END+LEFT ARROW |
| End, Right |
CTRL+RIGHT ARROW or END+RIGHT ARROW |
| Home |
CTRL+HOME |
| Tab |
CTRL+PAGE DOWN |
| Shift+Tab |
CTRL+PAGE UP |
| PgUp, PgDn |
PAGE UP or PAGE DOWN |
Transition navigation keys
These navigation keys can be used to make the transition between Lotus 1-2-3 and Microsoft Excel. To select transition navigation keys, press ALT+T and then press O (Tools menu, Options command), press CTRL+TAB to select the Transition tab, and then press ALT+K to select the Transition navigation keys check box.
| Press |
To move |
| SHIFT+TAB or CTRL+LEFT ARROW |
One screen to the left |
| TAB or CTRL+RIGHT ARROW |
One screen to the right |
| CTRL+PAGE DOWN |
To the next sheet in a workbook |
| CTRL+PAGE UP |
To the previous sheet in a workbook |
| HOME |
To the first cell on the sheet (the cell in the upper-left corner) |
Use the following text-alignment prefix characters to assign alignment formats as you enter data in cells.
| Press |
To |
| ' (apostrophe) |
Left align data in the cell |
| " (quotation mark) |
Right align data in the cell |
| ^ (caret) |
Center data within the cell |
| \ (backslash) |
Repeat characters across the cell |